KACE Product Support Question
Report to show devices that DON'T have a software title installed?
Answer Chosen by the Author
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