Include Patch ID, Vendor Name, Patch installation date, Deploy status, IP address, Last logon user of each failed patch,

and group by machine.

Answer Summary:
SELECT PP.VENDOR AS VENDOR, PP.IDENTIFIER, MS.DEPLOY_STATUS_DT AS DEPLOYED_DATE, MS.DEPLOY_STATUS, M.NAME AS ComputerName,IP, M.USER_LOGGED as USER_LOGGED FROM PATCHLINK_MACHINE_STATUS MS JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID JOIN MACHINE M ON M.ID = MS.MACHINE_ID WHERE MS.DEPLOY_STATUS NOT LIKE '%SUCCESS%' AND MS.DEPLOY_STATUS_DT > CURDATE() - INTERVAL 30 DAY ORDER BY M.NAME
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2
SELECT PP.VENDOR AS VENDOR, PP.IDENTIFIER, MS.DEPLOY_STATUS_DT AS DEPLOYED_DATE,

MS.DEPLOY_STATUS, M.NAME AS ComputerName,IP,

M.USER_LOGGED as USER_LOGGED

FROM PATCHLINK_MACHINE_STATUS MS

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

JOIN MACHINE M ON M.ID = MS.MACHINE_ID

WHERE MS.DEPLOY_STATUS NOT LIKE '%SUCCESS%' AND

MS.DEPLOY_STATUS_DT > CURDATE() - INTERVAL 30 DAY

ORDER BY M.NAME
Answered 08/02/2012 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share