/bundles/itninjaweb/img/Breadcrumb_cap_w.png

Include Vendor Name, Patch ID, Patch description, Release Date, Impact of each patch

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
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

Answers

2

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
Answered 08/02/2012 by: dugullett
Red Belt

  • Also can you add the k1000 reporting tag to all of these? It will help people reference in the future.
Please log in to comment