K1000 Report to Detect Devices Missing Specific Software
Good afternoon Ninjas!
I'm new to KACE, and not very familiar with SQL, but i wanted to see if i could get some help creating a KACE Report to detect & list devices that are missing a specific piece of software.
Thank you!
-josh
Answers (1)
Try:
SELECT MACHINE.ID AS TOPIC_ID,
MACHINE.NAME AS SYSTEM_NAME
FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT MSJ
ON MSJ.MACHINE_ID = MACHINE.ID
LEFT JOIN SOFTWARE
ON SOFTWARE.ID = MSJ.SOFTWARE_ID
WHERE MACHINE.ID NOT IN ( SELECT MACHINE.ID
FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT MS
ON MS.MACHINE_ID = MACHINE.ID
LEFT JOIN SOFTWARE S
ON S.ID = MS.SOFTWARE_ID
WHERE S.DISPLAY_NAME LIKE "%FIREFOX%"
AND S.IS_PATCH = 0
GROUP BY MACHINE.ID
)
GROUP BY MACHINE.ID
This can be used as a smart label
