How to list the computers with partial/empty Software Inventory (Signature Scan)

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

It is possible to create a dynamic groups containing all computers with partial of empty Software signature scan inventory ?

This could be useful to check why Software Inventory is not working on some machines and take action on them.

 

Instructions:

1- In DSM GUI, create a new Query (target = Computers)

1.jpg

 

2- In "Query Designer" add (Agent Origin = 'CA')

2.jpg

 

3- If there are some machines inventoried by RVI add these arguments in order to exclude the RVI machines :

AND

NOT

(Host name Like 'VMware ESX*')

AND

NOT

(Host name Like 'Microsoft Hyper-v*')

AND

NOT

(Host name Like 'IBM Server*')

 

3.jpg

 

Remark :

Host name can be found under "General Information - Computer"

 

 

4- Add following arguments :

AND

NOT

 and click on "Advanced Argument".

 

Fill the fields like this :

 Pseudo Text : Software Inventory OK

Table : -Any-

Additional WHERE clause

select asset_source_uuid from ca_discovered_software where dis_source_type_id in (1,2group by asset_source_uuid having COUNT(*)>5

4.jpg

 

Final query looks like :

4b.jpg

 

 

Remark :

Software Inventory is considered as OK when there are more than 5 items in the Software Inventory list.

Change  "COUNT(*)>5" by another number if 5 is not a good number to determine a wrong Software Inventory in your environment.

 

 

 5- Save the query (ex of name : Software Inventory Not OK)

 

 

 6- Under "Computer and Users" create a new Group (ex: Software Inventory Not OK)

 

In Query Tab, select the query created in previous steps and select an engine for evaluation :

6.jpg

 

7- Evaluate the group.

7.jpg

 

 

It should be filled with machines which have empty or incorrect Software inventory (signature scan).

 

8.jpg

 

 

8- It is possible to force a full Software Inventory collect on these machines.

Select all machines in the group and right click on the selection. In menu select "Asset Jobs - Activate Job Check..."

9.jpg

 

 Select "Rescan Software Inventory" and "Re-collect" in order to force a full Software Inventory collect.

9b.jpg