I wanted to know what the script would need to look like if I just wanted to run a report on one machine in particular (ex. DC) and show all the patches on that machine and what patches are missing. If it could also show the date it was patched then that would be awesome as well!!

 

Thanks in advance guys!!

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

5

Something like this? DEPLOY_STATUS_DT is when Kace deployed. STATUS_DT will be when it was patched other than Kace. Not for sure will work best for you.

Replace DC% with your machine name. 

SELECT PP.TITLE, STATUS, DEPLOY_STATUS_DT AS DATE_PATCHED

FROM PATCHLINK_MACHINE_STATUS P

JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = P.PATCHUID

JOIN MACHINE M ON M.ID = P.MACHINE_ID

WHERE M.NAME LIKE 'DC%'

ORDER BY STATUS DESC
Answered 08/07/2012 by: dugullett
Red Belt

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