Create a report for software missing from a given computer

[Jason Wright]

Good Afternoon,

I'm trying to use the reporting function to show me all computers where a certain software is not currently installed (let's say Chrome for this example).

It's easy enough to start with cmdb_sam_sw_install and filter down to records where the name is "Chrome" and look at the "Installed On" field.

HOWEVER,

switching the report to "Does Not Contain" will only remove the records for that particular installation (other entries for that specific computer CI will still exist).  Also, you cannot start with the cmdb_ci_computer table and dot-walk down to cmdb_sam_sw_install, as it is not an option.  And you cannot create a related list condition since the 2 tables do not have a 1:1 relationship.

Short of manually dumping all computer CIs and all Chrome entries in the software table, then comparing the two, I'm not sure how to go about accomplishing this.  Any assistance is appreciated.

(Version: Utah)

[Adam Peterson]

Did you ever find a solution for this?

[Jason Wright]

Yes,

The answer is to create a database view (left-join) between the two tables using the "Installed On" attribute.  Then you can filter down to certain attributes are empty (forgive me, the specifics attributes have been lost to time in our instance.