/build/static/layout/Breadcrumb_cap_w.png

Does anyone have a good report setup for Patching Compliance?

I need an overview report that shows the overall patching status of our environment that can be submitted to our CIO. We are using the K1000 for patching and are an all Dell Shop. Our current environment is Windows 7 only.

1 Comment   [ + ] Show comment
  • What product are you using? Can you add some relevant tags to your post please? - dunnpy 9 years ago

Answers (1)

Posted by: h2opolo25 9 years ago
Red Belt
1
Here is one that will show you the completion of a specific Patch Job per computer.

select M.NAME as NAME, M.IP as IP_ADDRESS, KT.PHASE as STATUS, Concat('Patched: ', PS.PATCHED,' , ','Not Patched: ',  PS.NOTPATCHED,' , ','Detect Failures: ',  PS.DETECT_FAILURES) as PATCH_RESULTS, PS.LAST_RUN as DATE 
from MACHINE M
left join PATCHLINK_SCHEDULE_MACHINE_STATUS PS on PS.MACHINE_ID = M.ID
left join PATCHLINK_SCHEDULE PSS on PSS.ID = PS.PATCHLINK_SCHEDULE_ID
left join KBSYS.KONDUCTOR_TASK KT on KT.KUID = M.KUID
where PSS.DESCRIPTION = 'PATCH JOB NAME'
and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE


Here's one that will show you patches installed in the last day (you can make it last week, month, minute, etc...)

select M.NAME as COMPUTER_NAME, PP.TITLE as PATCH_NAME, PP.IMPACTID as PATCH_IMPACT, MS.DEPLOY_STATUS as PATCH_STATUS, MS.DEPLOY_STATUS_DT as INSTALL_DATE from MACHINE M
left join PATCHLINK_MACHINE_STATUS MS on MS.MACHINE_ID = M.ID
left join KBSYS.PATCHLINK_PATCH PP on PP.UID = MS.PATCHUID
where MS.DEPLOY_STATUS_DT > subdate(now(), interval 1 day)
ORDER BY M.NAME, PP.TITLE

Comments:
  • What does "Patch Job Name" refer to? - derrick499 9 years ago
    • The name you gave to your patch schedule. If you go to Security >> Patch Management >> Patch Schedules and look at the Name column, just enter one of those in the query. - h2opolo25 9 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

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