Reporting on computers with no installed software

[Richard Nelson1]

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

[Mike_R · Accepted solution]

You can use the Related List Conditions in the report module

[Richard Nelson1]

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

[kayeelaw]

Hi Mike,  I tried to follow your steps but it still shows Computers with Software installs.   Am i missing a field or step?

[kayeelaw]

Hiya,  i tried to follow your instructions as per the screen shot above but I can still see computers with Software installed,  is there another field i need to fill in ?