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   [ + ] Show Comments

Comments

Please log in to comment

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
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share