- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 06:40 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 06:44 AM
You can use the Related List Conditions in the report module
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 06:44 AM
You can use the Related List Conditions in the report module
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2023 07:04 AM
Thanks Mike, It was under my nose all the time. It's not obvious that the criteria is a choice list?