KACE Report to find machines missing a hotfix
How to get report on machines that haven't patched with KB2506143?
1 Comment
[ + ] Show comment
-
There is a built in report you could clone and change the KB number and have it look for machines missing it vs finding it. Or what chucksteel has for you below. - nshah 9 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 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%"