How to get report on machines that haven't patched with KB2506143?
1 Comment   [ + ] Show Comment

Comments

  • 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.
Please log in to comment

Answers

2
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%"

Answered 07/21/2015 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity