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
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share