Customized Report New security patch released in last 30 days
Include Vendor Name, Patch ID, Patch description, Release Date, Impact of each patch
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
SELECT TITLE, VENDOR, IDENTIFIER, IMPACTID, RELEASEDATE FROM KBSYS.PATCHLINK_PATCH WHERE RELEASEDATE > CURDATE() - INTERVAL 30 DAY AND IMPACTID LIKE '%CRITICAL%' ORDER BY VENDOR
SELECT TITLE, VENDOR, IDENTIFIER, IMPACTID, RELEASEDATE FROM KBSYS.PATCHLINK_PATCH WHERE RELEASEDATE > CURDATE() - INTERVAL 30 DAY AND IMPACTID LIKE '%CRITICAL%' ORDER BY VENDOR
Please log in to answer
Posted by:
dugullett
12 years ago
There's really not a field for "security" this will include all critical updates in the last 30 days. This should cover security. The other option would be to use TITLE LIKE '%SECURITY%'.
SELECT TITLE, VENDOR, IDENTIFIER, IMPACTID, RELEASEDATE FROM KBSYS.PATCHLINK_PATCH WHERE RELEASEDATE > CURDATE() - INTERVAL 30 DAY AND IMPACTID LIKE '%CRITICAL%' ORDER BY VENDOR
Comments:
-
Also can you add the k1000 reporting tag to all of these? It will help people reference in the future. - dugullett 12 years ago
