/build/static/layout/Breadcrumb_cap_w.png

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
Posted by: dugullett 11 years ago
Red Belt
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

Comments:
  • Also can you add the k1000 reporting tag to all of these? It will help people reference in the future. - dugullett 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ