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?

[march]

Nobody have an idea for this? I can't imagine we are the only company with such a requirements. Or maybe you achieve this same need another way?

[march]

I really can't find a correct way to achieve this. For now, we generate 2 reports and do a vlookup through excel. I would be really happy to be able to generate this report directly out of SNOW.

[tony_fugere]

I think this is what you're trying to achieve. Build a Database View like this and click Try It:

[march]

Thanks Tony.
Well, this is giving me a list of all software linked to the correct hardware.
To have what i really want, i should be able to first filter the content of the si_software_instance (to the software i want to report on) before doing the join with the computer table (left join).
So the view will show me all the computer with empty software fields if the software i want to report on is not installed and and with the software name if it contains that software.
Is that feasible? e.g. to add AND operator and to use a LIKE operator.

Or maybe i missed something in the proposed solution...