PAtch management configuration

Document ID : KB000045293
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

In DSM Web Console, under Patch Management it is possible to create some configurations to automate the acceptance and approval, control distribution of patches.
A configuration should be defined with a Manufacturer and a Category.
What is a Category for a Patch Management configuration ?
 
Untitled.jpg
 
 

Answer: 

Category is the Operating System the patches apply to.

On July 2016 there were 13 categories :
 
 
Windows Vista 32-Bit Rollups
Windows Vista 64-Bit Rollups
Windows 7 32-Bit Rollups
Windows 7 64-Bit Rollups
Windows 8 32-Bit Rollups
Windows 8 64-Bit Rollups
Windows 8.1 32-Bit Rollups
Windows 8.1 64-Bit Rollups
Windows Server 2008 32-Bit Rollups
Windows Server 2008 64-Bit Rollups
Windows Server 2008 R2 64-Bit Rollups
Windows Server 2012 64-Bit Rollups
Windows Server 2012 R2 64-Bit Rollups
 
 
When we select a manufacturer, all OS categories which have at least one UPM Patch associated to the selected manufacturer is displayed and could be chosen.
 
On July 2016, Category appears only for patches with Manufacturer "CA Content Team".
 
This SQL Query returns the list of UPM Patches which are associated to a category :
 
use mdb 
SELECT c.company_name 'Manufacturer', category_name 'Category', ipkg_name 'UPM Package Name'
FROM ca_install_package p, ca_category_def d, ca_company c, ca_software_def s
WHERE p.category_uuid=d.category_uuid and p.sw_def_uuid=s.sw_def_uuid and s.manufacturer_uuid=c.company_uuid
ORDER BY 1,2,3

 

 
Here are some examples :
 
ManufacturerCategoryUPM Package Name
   
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1604.00
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1605.00
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1606.00
CA Content TeamWindows 7 32-Bit RollupsCA - Win 7 SP1 32Bit x86 - Security IntelliRollup v1607.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1605.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1606.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1604.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 7 SP1 64Bit x64 - Security IntelliRollup v1607.00
CA Content TeamWindows 7 64-Bit RollupsCA - Win 7 SP1 64Bit x64 - Security IntelliRollup v1608.00
CA Content TeamWindows 8 32-Bit RollupsCA - Win 8 Gold 32Bit x86 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 8 32-Bit RollupsCA - Win 8 Gold 32Bit x86 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 8 64-Bit RollupsCA - Win 8 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 8 64-Bit RollupsCA - Win 8 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Office 32Bit - Security IntelliRollup v1607.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1607.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1605.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1606.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - Security IntelliRollup v1607.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Gold 32Bit x86 - Security IntelliRollup v1608.00
CA Content TeamWindows 8.1 32-Bit RollupsCA - Win 8.1 Post Gold 32Bit x86 OS Only - FULL Security Rollup v1608.00
CA Content TeamWindows 8.1 64-Bit RollupsCA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows 8.1 64-Bit RollupsCA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows 8.1 64-Bit RollupsCA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1605.00
CA Content TeamWindows 8.1 64-Bit RollupsCA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1606.00
CA Content TeamWindows 8.1 64-Bit RollupsCA - Win 8.1 Gold 64Bit x64 - Security IntelliRollup v1608.00
CA Content TeamWindows Server 2008 32-Bit RollupsCA - Win 2008 SP2 32Bit x86 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Server 2008 32-Bit RollupsCA - Win 2008 SP2 32Bit x86 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows Server 2008 64-Bit RollupsCA - Win 2008 SP2 64Bit x64 - BETA -  Security IntelliRollup v1512.00
CA Content TeamWindows Server 2008 64-Bit RollupsCA - Win 2008 SP2 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows Server 2008 R2 64-Bit RollupsCA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Server 2008 R2 64-Bit RollupsCA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1601.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1605.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1606.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - Security IntelliRollup 1607.00
CA Content TeamWindows Server 2012 64-Bit RollupsCA - Win 2012 Gold 64Bit x64 - Security IntelliRollup v1608.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Office 32 Bit - DELTA Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Office 64 Bit - FULL Security Rollup v1607.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Office EN 32/64 Bit - FULL Security Rollup v1602.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 Post SP2 32Bit x86 OS Only - FULL Security Rollup v1602.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 Post SP2 32Bit x86 OS Only - FULL Security Rollup v1607.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 Post SP2 64Bit x64 OS Only - DELTA Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 Post SP2 64Bit x64 OS Only - DELTA Security Rollup v1607.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1605.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1607.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1605.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1605.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 2012 R2 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 7 Post SP1 32Bit x86 OS Only - FULL Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 7 Post SP1 32Bit x86 OS Only - FULL Security Rollup v1607.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 8.1 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1603.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win 8.1 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 32Bit x86 OS Only - DELTA Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 32Bit x86 OS Only - FULL Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 32Bit x86 OS Only - FULL Security Rollup v1606.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1603.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1604.00
CA Content TeamWindows Server 2012 R2 64-Bit RollupsCA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1605.00
CA Content TeamWindows Vista 32-Bit RollupsCA - Win Vista SP2 32Bit x86 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Vista 32-Bit RollupsCA - Win Vista SP2 32Bit x86 - BETA - Security IntelliRollup v1601.00
CA Content TeamWindows Vista 64-Bit RollupsCA - Win Vista SP2 64Bit x64 - BETA - Security IntelliRollup v1512.00
CA Content TeamWindows Vista 64-Bit RollupsCA - Win Vista SP2 64Bit x64 - BETA - Security IntelliRollup v1601.00