Customized Report: Machine not compliant(patch)
Include missed Patch ID, Vendor Name, IP address, Last logon user and group by machine.
0 Comments
[ + ] Show comments
Answers (1)
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
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
Please log in to answer
Posted by:
dugullett
11 years ago
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
