Reporting on computers with no installed software

Richard Nelson1
Tera Contributor

Hi all,

 

I'm trying to create a report that shows all CI in the class 'computer' which do not have running software assigned.  The aim is to identify the shortfall in terms of software discovery so I can isolate and address them. 

 

So far I have tried to use the CMDB Query Builder to show me computers with a relationship to the installed software table.  I would then have to subtract the distinct 'Installed on' CIs from a list of all computers in the CMDB. 

 

The issue with this approach is the large number of line items that need to be extracted in Excel and filtered.  

 

Has anyone managed to create a query that shows computers Not shown as 'Installed On' on the installed software table.  i.e. the reverse of the query builder supported functionality?

 

Thanks in advance,  Richard

1 ACCEPTED SOLUTION

Mike_R
Kilo Patron
Kilo Patron

You can use the Related List Conditions in the report module

Mike_R_0-1672929839755.png

 

 

View solution in original post

2 REPLIES 2

Mike_R
Kilo Patron
Kilo Patron

You can use the Related List Conditions in the report module

Mike_R_0-1672929839755.png

 

 

Thanks Mike, It was under my nose all the time.  It's not obvious that the criteria is a choice list?