Create report listing computers without a specific software title
I'm new to KACE (we're running version 6.0) and want to create a report that lists computers that are missing a specific software title. How can I do this?
Community Chosen Answer
SELECT NAME AS 'Machine Name' FROM MACHINE
WHERE NAME NOT IN (SELECT M.NAME FROM MACHINE M JOIN MACHINE_SOFTWARE_JT MSJ ON (MSJ.MACHINE_ID = M.ID)
JOIN SOFTWARE S ON (S.ID = MSJ.SOFTWARE_ID) WHERE S.DISPLAY_NAME like '%Software Title%')
ORDER BY NAME
All you have to do is change the software title (bolded).