Reporting on Software not installed

[march]

We are collecting the laptop/desktop information through the Help the Help Desk in the login script. Now, as part of a compliance check, we need to report on computer not running a certain piece of software.

e.g.:
Hostname Software
COM-0001 SoftwareA 1.2.3
COM-0003
COM-0004 SoftwareA 1.2.3

Looking at this report we would see which machine don't hold that mandatory software.
We found it quite easy to report on discovered machines, on machines running the software, but i can't find an easy way to have a single report listing the discovered machine together with the information around that specific software.

Anybody encounter the same kind of requirement?

[kaddie2190]

Hi - Did you ever figure out a proper filter to get this scenario to work? I have the same requirement now in my company, and cannot seem to get a proper filter.
Thanks

[david_walters]

Hi,

Did you ever get anywhere with this? I've been watching this for a while waiting for a solution.

thanks.

[TSP666]

Also very interested by this, it seems an obvious requirement so am surprised that it is not available OOB.

[brad_foohey]

I approached this a little different way.   In my scenario, i was looking to see if very specific software was NOT installed.   In my example, it's "Symantec Endpoint Protection Client 12.1" The script is currently hardcoded but if you spent a little time it would be easy to make more generic.

I compared the cmdb_ci_computer table against the cmdb_sam_sw_install table using a script and then used the results of the script in a report on the cmdb_ci_computer table.

So here are the mechanics to make this work

1. Add a script include (system definition / script include) and load the script (attached)   I named mine SymantecNotFound
2. Alter the script to reference the Display Name or model of the software you are validating if it is installed ( line 15 in the script)
3. Create a report on the cmdb_ci_computer table and filter on the script.   The script returns a string of sys_id values so you filter on the sys_id and insert the script
   1. Sys_id is javascript:SymantecNotFound(); (see screeshot)

Hope this helps someone

[TSP666]

Hello Sarah,

Thanks for your feedback, please could you share your script.

I am trying another approach using a pivot table where I list a software that should normally be on all workstations + the software I am interested in (Kaspersky).

Regards

Tony