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