Include missed Patch ID, Vendor Name, IP address, Last logon user and group by machine.

Answer Summary:
SELECT PP.TITLE AS DISPLAY_NAME, PP.IDENTIFIER, 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.STATUS = 'NOTPATCHED' ORDER BY M.NAME
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2
SELECT PP.TITLE AS DISPLAY_NAME, PP.IDENTIFIER,

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.STATUS = 'NOTPATCHED'

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