How to automate the acceptance and approval of patches in Patch Management?
Article ID: 45293
Updated On:
Products
CA Client Automation - IT Client Manager
CA Client Automation
CA Client Automation - Patch Manager
Issue/Introduction
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?
Environment
Client Automation - All versions.
Resolution
Category is the Operating System the patches apply to the chosen manufacturer.
On April 2022 there were 18 categories for manufacturer 'CA Content Team' :
Google Chrome
Microsoft Edge
Mozilla Firefox
Patch Me intellirollup
Windows 10 32-Bit and 64-Bit Rollups
Windows 7 32-Bit Rollups
Windows 7 64-Bit Rollups
Windows 8.1 32-Bit Rollups
Windows 8.1 64-Bit Rollups
Windows Prereq Rollups
Windows Prerequisite 32-Bit and 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
Windows Servicing Stack 32-Bit and 64-Bit Rollups
Windows Vista 32-Bit Rollups
Microsoft Edge
Mozilla Firefox
Patch Me intellirollup
Windows 10 32-Bit and 64-Bit Rollups
Windows 7 32-Bit Rollups
Windows 7 64-Bit Rollups
Windows 8.1 32-Bit Rollups
Windows 8.1 64-Bit Rollups
Windows Prereq Rollups
Windows Prerequisite 32-Bit and 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
Windows Servicing Stack 32-Bit and 64-Bit Rollups
Windows Vista 32-Bit Rollups
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 :
| Manufacturer | Category | UPM Package Name |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1604.00 |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1605.00 |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - BETA - Security IntelliRollup v1606.00 |
| CA Content Team | Windows 7 32-Bit Rollups | CA - Win 7 SP1 32Bit x86 - Security IntelliRollup v1607.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1605.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1606.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 7 SP1 64Bit x64 - BETA - Security IntelliRollup v1604.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 7 SP1 64Bit x64 - Security IntelliRollup v1607.00 |
| CA Content Team | Windows 7 64-Bit Rollups | CA - Win 7 SP1 64Bit x64 - Security IntelliRollup v1608.00 |
| CA Content Team | Windows 8 32-Bit Rollups | CA - Win 8 Gold 32Bit x86 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 8 32-Bit Rollups | CA - Win 8 Gold 32Bit x86 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 8 64-Bit Rollups | CA - Win 8 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 8 64-Bit Rollups | CA - Win 8 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Office 32Bit - Security IntelliRollup v1607.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1607.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1605.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - BETA - Security IntelliRollup v1606.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - Security IntelliRollup v1607.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Gold 32Bit x86 - Security IntelliRollup v1608.00 |
| CA Content Team | Windows 8.1 32-Bit Rollups | CA - Win 8.1 Post Gold 32Bit x86 OS Only - FULL Security Rollup v1608.00 |
| CA Content Team | Windows 8.1 64-Bit Rollups | CA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows 8.1 64-Bit Rollups | CA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows 8.1 64-Bit Rollups | CA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1605.00 |
| CA Content Team | Windows 8.1 64-Bit Rollups | CA - Win 8.1 Gold 64Bit x64 - BETA - Security IntelliRollup v1606.00 |
| CA Content Team | Windows 8.1 64-Bit Rollups | CA - Win 8.1 Gold 64Bit x64 - Security IntelliRollup v1608.00 |
| CA Content Team | Windows Server 2008 32-Bit Rollups | CA - Win 2008 SP2 32Bit x86 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Server 2008 32-Bit Rollups | CA - Win 2008 SP2 32Bit x86 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows Server 2008 64-Bit Rollups | CA - Win 2008 SP2 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Server 2008 64-Bit Rollups | CA - Win 2008 SP2 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows Server 2008 R2 64-Bit Rollups | CA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Server 2008 R2 64-Bit Rollups | CA - Win 2008 R2 SP1 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1601.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1605.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup 1606.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - Security IntelliRollup 1607.00 |
| CA Content Team | Windows Server 2012 64-Bit Rollups | CA - Win 2012 Gold 64Bit x64 - Security IntelliRollup v1608.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Office 32 Bit - DELTA Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Office 64 Bit - FULL Security Rollup v1607.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Office EN 32/64 Bit - FULL Security Rollup v1602.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 Post SP2 32Bit x86 OS Only - FULL Security Rollup v1602.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 Post SP2 32Bit x86 OS Only - FULL Security Rollup v1607.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 Post SP2 64Bit x64 OS Only - DELTA Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 Post SP2 64Bit x64 OS Only - DELTA Security Rollup v1607.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1605.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2008 R2 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1607.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1605.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Gold 64Bit x64 - BETA - Security IntelliRollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Post Gold 64Bit x64 OS Only - DELTA Security Rollup v1605.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 2012 R2 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 7 Post SP1 32Bit x86 OS Only - FULL Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 7 Post SP1 32Bit x86 OS Only - FULL Security Rollup v1607.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 8.1 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1603.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win 8.1 Post Gold 64Bit x64 OS Only - FULL Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 32Bit x86 OS Only - DELTA Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 32Bit x86 OS Only - FULL Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 32Bit x86 OS Only - FULL Security Rollup v1606.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1603.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1604.00 |
| CA Content Team | Windows Server 2012 R2 64-Bit Rollups | CA - Win Vista Post SP2 64Bit x64 OS Only - FULL Security Rollup v1605.00 |
| CA Content Team | Windows Vista 32-Bit Rollups | CA - Win Vista SP2 32Bit x86 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Vista 32-Bit Rollups | CA - Win Vista SP2 32Bit x86 - BETA - Security IntelliRollup v1601.00 |
| CA Content Team | Windows Vista 64-Bit Rollups | CA - Win Vista SP2 64Bit x64 - BETA - Security IntelliRollup v1512.00 |
| CA Content Team | Windows Vista 64-Bit Rollups | CA - Win Vista SP2 64Bit x64 - BETA - Security IntelliRollup v1601.00 |
Feedback
Yes
No
Powered by
