Client Automation - How to create a report on installation or not of a specific patch ?

Document ID : KB000122260
Last Modified Date : 06/12/2018
Show Technical Document Details
Introduction:
How to create a report to check if a specific package (Microsoft Patch KB for example) is installed or not ?
Instructions:
A report can be done using "Software Inventory Signature Scan" or "General Inventory"

Example : For patch MS14-040 - Windows8.1-KB2961072-x64 for Windows Server 2012 R2 Standard x64
 
User-added image
 
 
User-added image


 

Method using "Software Inventory Signature Scan"


1- In DSM Explorer create a query to find all computers with OS Windows Server 2012 R2 Standard x64 and with patch MS14-040 - Windows8.1-KB2961072-x64
Go under Queries and create a new query of type Computers
 
User-added image

User-added image



2- In Query Designer, Click on Software and "Discovered Software".
 
User-added image



3- In Add Argument, expand Software definitions, Categories and look for "Operating Systems" category
 
User-added image




4- Under "Operating Systems" category look for the Operating System (example : Windows Server 2012 R2 Standard x64).
Expand it, select the release and click OK to add it in the query.
 
User-added image
 
User-added image



5- In Boolean Operators, click on AND to add it.
 
User-added image


6- Repeat steps 2 to 4. In step 4 expand the release and look for the patch (example MS14-040 - Windows8.1-KB2961072-x64)
 
User-added image



7- Click on it and OK button to add it in the query.
 
User-added image



8- Click OK and give a name to the query (ex : Windows Server 2012 R2 Standard x64 - Patch KB2961072 Installed)
 
User-added image



9- Do a copy of this query and add Boolean NOT just after AND :
 
User-added image



10- Save the query with a new name (ex : Windows Server 2012 R2 Standard x64 - Patch KB2961072 NOT Installed)

2 queries are created :
 
User-added image



11- Open DSM Report and create a new report of type "Asset or User Report"
 
In General tab give a name like "Computers Windows 2012 R2 Standard x64 with KB2961072"
In Query tab, under DSM Query select the first query created.
 
User-added image



12- Click OK to validate the report creation

13- Do the same 2 last steps for report "Computers Windows 2012 R2 Standard x64 without KB2961072" by selecting second DSM Query

14- 2 reports are created to return machines with and without KB2961072
 
User-added image



 

Method using "General Inventory"

1- In DSM Explorer create a query to find all computers with OS Windows Server 2012 R2 Standard x64 and with patch MS14-040 - Windows8.1-KB2961072-x64
Go under Queries and create a new query of type Computers
See step 1 above of Software Inventory method.


2- In Query Designer, expand Inventory and click on Discovered Inventory
 
User-added image



3- In "Add Argument", expand Inventory/General Inventory/Operating System/System Updates/<Any>
Click on Update attribute and put the KB name in Value :
 
User-added image


4- Click OK.
In Boolean Operators click AND
 
User-added image


5- In Insert Argument, click on General Information/Computer :
 
User-added image


6- In Select Field, click on Classification/Class or subclass
In the listbox, choose <more...>
 
User-added image


7- In "Search possible values", enter the criteria for find the Operating Systems.
Example :
For Windows Server 2012 R2, I enter *2012 R2*
 
User-added image

Then I select "Windows Server 2012 R2" and I click OK (2 times).

The argument for OS is added.
 
User-added image



8- Do the same steps as steps 8 to 14 above of method using Software Inventory Signature Scan.
For second query put the NOT operator at beginning.
 
User-added image