1 2 Previous Next 17 Replies Latest reply on Mar 6, 2020 9:23 PM by Scott Rabinow

    Adding Windows Server 2019 to catalogs

    David Dell
      Share This:

      We recently upgraded to TSSA 8.9.4.292 because it has support for Server 2019.  However, when I open our catalogs and click the plus for the product filters, I do not see an option to add "Microsoft Windows Server 2019."  It has all the other older versions, but I don't see 2019 in the list.  Do I have to do something else to add it?

       

      A while back I had to do something to add newer SQL 2017 updates, but I can't remember what I did.  Sorry, I didn't find anything using a search.  Also, I guess I should add SQL Server 2019...which is not in the pick list either.

        • 2. Re: Adding Windows Server 2019 to catalogs
          David Dell

          That's what I was looking for.  Thanks!

          • 3. Re: Adding Windows Server 2019 to catalogs
            David Dell

            After updating our product_categories.xml file, adding Microsoft Windows Server 2019 to the filter list, and updating the catalog, I couldn't find any 2019 patches in the catalog.  This is what I added to the xml file.  It's basically a cut/paste of Server 2016, and I just changed the two sixes to nines. 

             

            <product_category name="Microsoft Windows Server 2019">

            <vendor name="Microsoft">

            <family name="Windows">

            <version name="Windows Server 2019" />

            </family>

            </vendor>

            </product_category>

             

            Could it be formatted wrong for 2019?  I never could never get windows_downloader.bat -configFile <DownloadConfigurationXMLFile> -exportIvantiProductCatalog <CSVFile> to work.  I got "Configuration file not exists at location" when I tried with no file and "Error reading configuration file. --- Cause:Parsing of configuration file" when I tried pointing to our original product_categories.xml file.  I'm not sure why I would need a file if I'm trying to get a list of everything.  I also tried windows_downloader.bat -listProducts, and it did provide a list of products, but Server 2019 wasn't on it.

            • 4. Re: Adding Windows Server 2019 to catalogs
              Bill Robinson

              the config file for the downloader is the normal downloader config file, not the existing product_categories.xml.

               

              if you run that you will get something that shows:

              Vendor Name, Family Name, Version Name, Product Name

              [...]

              "Microsoft","Windows","Windows Server 2019","Windows Server 2019 Datacenter",""

              "Microsoft","Windows","Windows Server 2019","Windows Server 2019 Essentials",""

              "Microsoft","Windows","Windows Server 2019","Windows Server 2019 Standard",""

              "Microsoft","Windows","Windows Server 2019","Windows Storage Server 2019 Standard",""

              "Microsoft","Windows","Windows Server 2019","Windows Storage Server 2019 Workgroup",""

              "Microsoft","Windows","Windows Server 2019","Windows Hyper-V Server 2019",""

               

              so what you filled in should be ok.  you shouldn't need to update the catalog to see the filters.  did you add/remove the custom xml from the patch global settings after making the changes ?

              • 5. Re: Adding Windows Server 2019 to catalogs
                David Dell

                No, the filters "seem" fine now.  I updated the catalog after updating the product_categories.xml file, and after adding Microsoft Windows Server 2019 to the filter list in the catalog.  The problem I'm having is that I still don't see any 2019 updates.  That's why I ran a catalog update, but still no hotfix or anything else found for Server 2019.

                 

                I modified the config file listed in the path in Patch Global Configuration - Windows directly.  I didn't make any changes in the GUI.

                • 6. Re: Adding Windows Server 2019 to catalogs
                  Bill Robinson

                  how are you looking for 2019 patches ?

                  • 7. Re: Adding Windows Server 2019 to catalogs
                    David Dell

                    I did a filter of "2019" in the catalog hotfix folder and "KB4532691."  Then I ran an analysis job on one of our 2019 servers, and it didn't list any OS updates missing or installed.

                    • 8. Re: Adding Windows Server 2019 to catalogs
                      Bill Robinson

                      on the Hotfixes patch smart group in the catalog, if you expand it and then right click on the smart group and choose filter and add the kb #, do you see any patches ?

                      • 9. Re: Adding Windows Server 2019 to catalogs
                        Bill Robinson

                        another thing to look at would be the cuj run log after you added the filter.  do you see it adding that kb to the catalog ?

                        • 10. Re: Adding Windows Server 2019 to catalogs
                          David Dell

                          Right, that's what I did with the hotfix filter.  I just looked at cuj logs, and I found this gem:

                          "Error: Filter [Microsoft Windows Server 2019] is misspelt or not supported, please revisit the configuration file."

                           

                          And of lesser priority, this too:

                          "Error: Filter [SQL Server 2019] is misspelt or not supported, please revisit the configuration file."

                          • 11. Re: Adding Windows Server 2019 to catalogs
                            Bill Robinson

                            can you attach (adv editor) the xml you are using ?

                            • 12. Re: Adding Windows Server 2019 to catalogs
                              David Dell

                              <!--

                              - ==== COPYRIGHT NOTICE START ====

                              - (C) Copyright 1996-2018 Bladelogic, Inc.

                              - The source code embodied here in is a trade secret of Bladelogic, Inc.

                              - All use, disclosure, and/or reproduction not specifically and expressly

                              - authorized, in writing, by Bladelogic, Inc. is prohibited.

                              - ==== COPYRIGHT NOTICE END ====

                              -->

                               

                               

                              <windows_product_categories>

                               

                               

                              <product_category name="Microsoft Windows Server 2008">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows Server 2008" />

                              <version name="Windows Server 2008 R2">

                              <exclude_products>

                              <product name="Windows Small Business Server 2011" />

                              <product name="Windows Home Server 2011" />

                              <product name="Windows MultiPoint Server 2011" />

                              </exclude_products>

                              </version>

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Windows Server 2012">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows Server 2012" />

                              <version name="Windows Server 2012 R2" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Windows Server 2016">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows Server 2016" />

                              </family>

                              </vendor>

                              </product_category>

                               

                              <product_category name="Microsoft Windows Server 2019">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows Server 2019" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="SQL Server 2014">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2014" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="SQL Server 2016">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2016" />

                              </family>

                              </vendor>

                              </product_category>

                               

                              <product_category name="SQL Server 2017">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2017" />

                              </family>

                              </vendor>

                              </product_category>

                               

                              <product_category name="SQL Server 2019">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2019" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Windows 8">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows 8" />

                              <version name="Windows 8.1" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Windows 7">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows 7" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Windows 10">

                              <vendor name="Microsoft">

                              <family name="Windows">

                              <version name="Windows 10" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Office 2010">

                              <vendor name="Microsoft">

                              <family name="Office">

                              <version name="Office 2010">

                              <exclude_products>

                              <product name="Microsoft Office 64-bit Components 2010" />

                              <product name="Microsoft Office 32-bit Components 2010" />

                              <product name="Microsoft Office 2010 Language Pack" />

                              <product name="Microsoft Office 2010 Language Pack x64" />

                              </exclude_products>

                              </version>

                              <version name="Word 2010" />

                              <version name="Access 2010">

                              <exclude_products>

                              <product name="Access 2010 Gold" />

                              </exclude_products>

                              </version>

                              <version name="Excel 2010" />

                              <version name="PowerPoint 2010" />

                              <version name="Publisher 2010" />

                              <version name="Outlook 2010" />

                              <version name="OneNote 2010" />

                              <version name="InfoPath 2010" />

                              <version name="PowerPoint Viewer 2010" />

                              <version name="Visio 2010" />

                              <version name="Project 2010">

                              <include_products>

                              <product name="Project 2010 MUI" />

                              <product name="Project 2010 MUI (x64)" />

                              </include_products>

                              </version>

                              <version name="Access Database Engine 2010" />

                              <version name="Word Server 2010" />

                              <version name="Proofing Tools 2010">

                              <include_products>

                              <product name="Proofing Tools 2010" />

                              <product name="Proofing Tools 2010 (x64)" />

                              </include_products>

                              </version>

                              <version name="Excel Services Components 2010" />

                              <version name="Excel Web App Components 2010" />

                              <version name="Office 2010 Filter Pack" />

                              <version name="Office Groove Server 2010" />

                              <version name="Office Pinyin IME 2010" />

                              <version name="Office Shared 2010">

                              <include_products>

                              <product name="Microsoft Office Shared 2010" />

                              <product name="Microsoft Office Shared 2010 (x64)" />

                              </include_products>

                              </version>

                              <version name="Project Web Front End Server 2010" />

                              </family>

                              <family name="Office Viewer">

                              <version name="Visio Viewer 2010">

                              <exclude_products>

                              <product name="Visio Viewer 2010 x64" />

                              </exclude_products>

                              </version>

                              <version name="Access Runtime 2010" />

                              </family>

                              <family name="Lync">

                              <version name="Lync 2010" />

                              <version name="Lync 2010 Attendant" />

                              <version name="Lync 2010 Attendee Admin" />

                              </family>

                              <family name="Lync Server">

                              <version name="Lync Server 2010" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Office 2013">

                              <vendor name="Microsoft">

                              <family name="Office">

                              <version name="Office 2013">

                              <exclude_products>

                              <product name="Microsoft Office 64-bit Components 2013" />

                              <product name="Microsoft Office 2013 Language Pack" />

                              <product name="Microsoft Office 2013 Language Pack x64" />

                              <product name="Microsoft Office 32-bit Components 2013" />

                              </exclude_products>

                              </version>

                              <version name="Word 2013" />

                              <version name="Access 2013" />

                              <version name="Excel 2013" />

                              <version name="PowerPoint 2013" />

                              <version name="Publisher 2013" />

                              <version name="Outlook 2013" />

                              <version name="OneNote 2013" />

                              <version name="InfoPath 2013" />

                              <version name="Visio 2013" />

                              <version name="Project 2013">

                              <include_products>

                              <product name="Project 2013 MUI" />

                              <product name="Project 2013 MUI (x64)" />

                              </include_products>

                              </version>

                              <version name="SkyDrive Pro 2013" />

                              <version name="Word Server 2013" />

                              <version name="Proofing Tools 2013" />

                              <version name="Access Services Server 2013" />

                              <version name="Office Server 2013">

                              <include_products>

                              <product name="Microsoft Education 2013 x64" />

                              </include_products>

                              </version>

                              <version name="Excel Services Components 2013" />

                              <version name="InfoPath Forms Services 2013" />

                              <version name="PowerPoint Services 2013" />

                              <version name="Office Shared 2013" />

                              <version name="Project Web Front End Server 2013" />

                              <version name="Server Proof 2013" />

                              <version name="Slide Library 2013" />

                              <version name="Visio Services 2013" />

                              <version name="Web Analytics 2013" />

                              </family>

                              <family name="Office Viewer">

                              <version name="Access Runtime 2013" />

                              <version name="Access Database Engine 2013" />

                              <version name="Visio Viewer 2013" />

                              </family>

                              <family name="Lync">

                              <version name="Lync 2013" />

                              </family>

                              <family name="SharePoint">

                              <version name="Search Server 2010 Core">

                              <include_products>

                              <product name="Microsoft Search Server 2010 Core x64" />

                              </include_products>

                              </version>

                              </family>

                              <family name="Lync Server">

                              <version name="Lync Server 2013" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Office 2016">

                              <vendor name="Microsoft">

                              <family name="Office">

                              <version name="Office 2016">

                              <exclude_products>

                              <product name="Microsoft Office 64-bit Components 2016" />

                              <product name="Microsoft Office 32-bit Components 2016" />

                              <product name="Microsoft Office Click to Run 2016" />

                              <product name="Microsoft DCF MUI 2016" />

                              <product name="Microsoft DCF MUI 2016 (x64)" />

                              <product name="Microsoft Office Language Interface Pack 2016" />

                              <product name="Microsoft Office Language Interface Pack 2016 (x64)" />

                              </exclude_products>

                              </version>

                              <version name="Word 2016" />

                              <version name="Access 2016" />

                              <version name="Excel 2016" />

                              <version name="PowerPoint 2016" />

                              <version name="Publisher 2016" />

                              <version name="Outlook 2016" />

                              <version name="OneNote 2016" />

                              <version name="InfoPath 2016" />

                              <version name="Access Runtime 2016" />

                              <version name="Access Database Engine 2016" />

                              <version name="SkyDrive Pro 2016" />

                              <version name="Proofing Tools 2016" />

                              <version name="Office Shared 2016" />

                              </family>

                              <family name="Office Viewer">

                              <version name="Access Runtime 2016" />

                              <version name="Access Database Engine 2016" />

                              </family>

                              <family name="Lync">

                              <version name="Lync 2016" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Office Web Apps">

                              <vendor name="Microsoft">

                              <family name="Office">

                              <version name="Office Server 2013">

                              <include_products>

                              <product

                              name="Microsoft Office Web Apps Application Server Components 2013 x64" />

                              </include_products>

                              </version>

                              <version name="Office Server 2010">

                              <include_products>

                              <product

                              name="Microsoft Office Web Apps Application Server Components 2010 x64" />

                              <product name="Microsoft Office Web Apps Proof 2010 x64" />

                              </include_products>

                              </version>

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="SQL Server 2008">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2008" />

                              <version name="SQL Server 2008 R2" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="SQL Server 2012">

                              <vendor name="Microsoft">

                              <family name="SQL Server">

                              <version name="SQL Server 2012" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="SharePoint">

                              <vendor name="Microsoft">

                              <family name="SharePoint">

                              <version name="SharePoint Foundation 2010 Core">

                              <include_products>

                              <product name="Microsoft SharePoint Foundation 2010 Core x64" />

                              </include_products>

                              </version>

                              <version name="SharePoint Server 2010" />

                              <version name="SharePoint Server 2013">

                              <include_products>

                              <product name="Microsoft SharePoint Server 2013 x64" />

                              <product name="Microsoft SharePoint Portal 2013 x64" />

                              </include_products>

                              </version>

                              <version name="Search Server 2010 Core">

                              <include_products>

                              <product name="Microsoft Search Server 2010 Core x64" />

                              </include_products>

                              </version>

                              <version name="SharePoint Foundation 2013 Core" />

                              <version name="SharePoint Designer 2010" />

                              <version name="SharePoint Server 2013 Client Components SDK" />

                              <version name="SharePoint Multilingual Solutions 2013" />

                              <version name="FAST Search Server 2010 for Sharepoint" />

                              </family>

                              <family name="Office">

                              <version name="Sharepoint Workspace 2010" />

                              <version name="Slide Library 2010" />

                              <version name="PerformancePoint Services For SharePoint 2013" />

                              <version name="Sharepoint Designer 2013" />

                              </family>

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="VMware">

                              <vendor name="VMware">

                              <family name="VMware Player" />

                              <family name="VMware Tools" />

                              <family name="VMware Workstation" />

                              <family name="VMware Horizon View Client" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="IIS">

                              <vendor name="Microsoft">

                              <family name="Internet Information Server" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Internet Explorer">

                              <vendor name="Microsoft">

                              <family name="Internet Explorer" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Windows Media Player">

                              <vendor name="Microsoft">

                              <family name="Windows Media Player" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Microsoft Exchange">

                              <vendor name="Microsoft">

                              <family name="Exchange Server" />

                              <family name="Exchange System Manager" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name=".Net Framework">

                              <vendor name="Microsoft">

                              <family name=".Net" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Java Virtual Machine">

                              <vendor name="Microsoft">

                              <family name="Virtual Machine" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="MSXML">

                              <vendor name="Microsoft">

                              <family name="MSXML" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="BizTalk Server">

                              <vendor name="Microsoft">

                              <family name="BizTalk Server" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Apache">

                              <vendor name="Apache Software Foundation"/>

                              </product_category>

                               

                               

                              <product_category name="DirectX">

                              <vendor name="Microsoft">

                              <family name="DirectX" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="WinZip">

                              <vendor name="WinZip" />

                              </product_category>

                               

                               

                              <product_category name="Adobe">

                              <vendor name="Adobe">

                              <family name="Reader" />

                              <family name="Distiller" />

                              <family name="Acrobat" />

                              <family name="Elements" />

                              <family name="AIR" />

                              <family name="Shockwave" />

                              <family name="InDesign" />

                              <family name="Adobe Photoshop" />

                              <family name="Illustrator" />

                              <family name="Bridge" />

                              <family name="Digital Editions" />

                              <family name="After Effects" />

                              <family name="Dreamweaver" />

                              <family name="Creative Cloud" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Firefox">

                              <vendor name="Mozilla Foundation">

                              <family name="Firefox" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="WSUS">

                              <vendor name="Microsoft">

                              <family name="WSUS" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Flash">

                              <vendor name="Adobe">

                              <family name="Flash" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Real Player">

                              <vendor name="Real">

                              <family name="RealPlayer" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Windows Defender">

                              <vendor name="Microsoft">

                              <family name="Defender" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Services for Unix">

                              <vendor name="Microsoft">

                              <family name="Services for Unix" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Visual Studio">

                              <vendor name="Microsoft">

                              <family name="Visual Studio" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Apple">

                              <vendor name="Apple" />

                              </product_category>

                               

                               

                              <product_category name="Blackberry">

                              <vendor name="Research In Motion" />

                              </product_category>

                               

                               

                              <product_category name="Skype">

                              <vendor name="Skype Technologies S.A." />

                              </product_category>

                               

                               

                              <product_category name="Citrix">

                              <vendor name="Citrix" />

                              </product_category>

                               

                               

                              <product_category name="Microsoft Silverlight">

                              <vendor name="Microsoft">

                              <family name="Silverlight" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Oracle OpenOffice.Org">

                              <vendor name="Oracle">

                              <family name="OpenOffice" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="7-zip">

                              <vendor name="7-Zip">

                              <family name="7-Zip" />

                              </vendor>

                              </product_category>

                               

                              <product_category name="Microsoft Windows Media Services">

                              <vendor name="Microsoft">

                              <family name="Windows Media Services" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Google">

                              <vendor name="Google" />

                              </product_category>

                               

                               

                              <product_category name="Opera Software ASA">

                              <vendor name="Opera Software ASA" />

                              </product_category>

                               

                               

                              <product_category name="Foxit Corporation">

                              <vendor name="Foxit Corporation" />

                              </product_category>

                               

                               

                              <product_category name="Hewlett-Packard">

                              <vendor name="Hewlett-Packard" />

                              </product_category>

                               

                               

                              <product_category name="RealVNC Free Edition">

                              <vendor name="RealVNC">

                              <family name="VNC" />

                              </vendor>

                              </product_category>

                               

                              <product_category name="PuTTY">

                              <vendor name="Simon Tatham" />

                              </product_category>

                               

                               

                              <product_category name="Wireshark Foundation">

                              <vendor name="Wireshark Foundation" />

                              </product_category>

                               

                               

                              <product_category name="Sourceforge.Net">

                              <vendor name="Audacity" />

                              <vendor name="Pidgin" />

                              <vendor name="FileZilla" />

                              <vendor name="KeePass" />

                              <vendor name="VideoLAN">

                              <family name="VLC" />

                              </vendor>

                              <vendor name="Gimp.org">

                              <family name="Gimp" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="Zimbra">

                              <vendor name="VMware">

                              <family name="Zimbra Desktop" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="CDBurnerXP">

                              <vendor name="CDBurnerXP" />

                              </product_category>

                               

                               

                              <product_category name="CoreFTP">

                              <vendor name="CoreFTP" />

                              </product_category>

                               

                               

                              <product_category name="LibreOffice">

                              <vendor name="LibreOffice" />

                              </product_category>

                               

                               

                              <product_category name="Rarlab">

                              <vendor name="Rarlab" />

                              </product_category>

                               

                               

                              <product_category name="Notepad++">

                              <vendor name="Notepad++" />

                              </product_category>

                               

                               

                              <product_category name="SCCM">

                              <vendor name="Microsoft">

                              <family name="SCCM" />

                              </vendor>

                              </product_category>

                               

                               

                              <product_category name="UltraVNC">

                              <vendor name="UltraVNC" />

                              </product_category>

                               

                               

                              </windows_product_categories>

                              • 13. Re: Adding Windows Server 2019 to catalogs
                                Bill Robinson

                                i used your file and i can get the sql server and server 2019 patches into a catalog w/ no issue:

                                 

                                • 14. Re: Adding Windows Server 2019 to catalogs
                                  Bill Robinson

                                  also 8.9.4p3 should ship w/ the 2019 stuff in there.  i would maybe try:

                                  - clear out the windows filter cache box

                                  - if there's a product-categories-filters.xml in the <file server>/patch/GlobalConstants, make a backup copy and remove it from the dir

                                  - go open a catalog and see what filters you see.

                                  1 2 Previous Next