Report to show devices that DON'T have a software title installed?
Answers (3)
I typically use the advanced search on the devices page and search something like the following:
Software Titles does not contain acrobat
This returns a list of machines that do not have any software with a title containing "acrobat."
I can probably use a similar logic in the reports if I need to, but these ad-hoc device queries usually do the trick.
Top Answer
This report shows the list of all computers that DO NOT have
"adobe acrobat" installed on them.
You can replace "adobe acrobat " with the software you want.
SELECT MACHINE.NAME AS SYSTEM_NAME FROM MACHINE WHERE (((not exists (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%adobe acrobat%')) )) ORDER BY SYSTEM_NAME