Report for patches on a certain machine
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!!
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
dugullett
11 years ago
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
