KACE Report to find machines missing a hotfix
How to get report on machines that haven't patched with KB2506143?
Please log in to answer
Posted by: chucksteel 5 years ago
This should work for you:
SELECT MACHINE_ID, PMS.PATCHUID, PMS.STATUS, PMS.STATUS_DT, P.TITLE, P.IMPACTID, M.NAME
FROM ORG1.PATCHLINK_MACHINE_STATUS PMS
JOIN KBSYS.PATCHLINK_PATCH P on P.UID = PMS.PATCHUID
JOIN MACHINE M on M.ID = PMS.MACHINE_ID
WHERE PMS.STATUS = "NOTPATCHED"
and P.TITLE LIKE "%KB2506143%"