Report to list Windows Updates installed
I am trying to build a report to list all the installed Windows updates on all client machines. I am looking to report which clients are not up to date with installed Windows Updates.
Windows updates are installed via WSUS and not KACE.
Any help will be appreciated.
SELECT M.NAME AS COMPUTER_NAME, PP.TITLE AS PATCH_NAME, DATE_FORMAT(PP.RELEASEDATE, '%Y-%m-%d') AS RELEASED
FROM PATCHLINK_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID = PP.UID
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
WHERE PP.IS_APP = '0'
AND MS.STATUS = 'NOTPATCHED'
AND PPS.STATUS = 0
AND PP.VENDOR = 'Microsoft Corp.'
ORDER BY M.NAME, PP.RELEASEDATE, PP.TITLE