/build/static/layout/Breadcrumb_cap_w.png

K1000 Report of Critical Patches deployed grouped by Vendor

Here is the SQL of a report to genereate a nice table of critical patches Patched, Un Patched and % complete by patch vendor.

Select P.VENDOR AS 'Crtitical Patches by Vendor',
COUNT(CASE WHEN S.STATUS='PATCHED' THEN S.MACHINE_ID END) as PATCHED,
COUNT(CASE WHEN S.STATUS='NOTPATCHED' THEN S.MACHINE_ID END) as UNPATCHED,
CONCAT(ROUND(COUNT(CASE WHEN S.STATUS='PATCHED' THEN S.MACHINE_ID END)/(COUNT(CASE WHEN S.STATUS='NOTPATCHED' THEN S.MACHINE_ID END)+COUNT(CASE WHEN S.STATUS='PATCHED' THEN S.MACHINE_ID END))*100),'%') AS 'Percent Patched'
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P, PATCHLINK_PATCH_STATUS PS
where
MACHINE.ID = S.MACHINE_ID and
PS.PATCHUID = P.UID and
S.PATCHUID = P.UID and
P.IMPACTID like "Critical" and
P.IS_SUPERCEDED = 0 and
PS.STATUS=0
group by P.VENDOR
order by P.VENDOR

 

We use this for compliance reporting. It provides exactly what we need! 


Comments

  • Great report, thanks for sharing!!!

    John - jverbosk 11 years ago
  • Glad you like it. - sklauminzer 11 years ago
  • thanks for the report - brighstarcuit 11 years ago
  • great report! - ryd003 7 years ago
  • This report is boss, thank you! - satchmo 7 years ago
This post is locked
 
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