/build/static/layout/Breadcrumb_cap_w.png

Need help with a report on 3rd party patching

I am 2 months into implementing K1000 (11.0) for my company. We have setup MS Windows patching and I fought through getting a SQL report working and then for the Microsoft Patches for all 4 environments. I basically just swapped out the L.NAME = Test1 for L.NAME = Test2 and so forth.

 

I now need to get a report for 3rd party patches. We are testing on 3-4 pretty standard Apps: Chrome, Adobe Reader, etc. I tried to copy the working MS patch report and replace the L.NAME with the 3rd party patching schedule and this does not appear to work. Here is the working reports SQL:

 

select M.NAME as 'MACHINE_NAME',USER_NAME as 'User'  ,OS_NAME as 'OS_Name'  ,sum(MS.PATCH_INSTALLED) as 'PATCHED'

  ,sum(!MS.PATCH_INSTALLED) as 'NOT_PATCHED'

  ,round((sum(MS.PATCH_INSTALLED) / (sum(MS.PATCH_INSTALLED) + sum(!MS.PATCH_INSTALLED))) * 100, 0) as 'PERCENT_PATCHED'

from

  PATCH_MACHINE_STATUS MS

  join KBSYS.PATCH PP on (PP.ID = MS.PATCH_ID)

  join PATCH_STATUS PPS on (PPS.PATCH_ID = PP.ID)

  join MACHINE M on (M.ID = MS.MACHINE_ID)

  join MACHINE_LABEL_JT ML on (M.ID = ML.MACHINE_ID)

  join LABEL L on (ML.LABEL_ID = L.ID)

where

 (PP.SEVERITY = 'Critical' OR PP.SEVERITY = 'Important')

 and PPS.STATUS = 0

  and PP.IS_SUPERCEDED = 0

  and L.NAME = 'SRV UD Servers'

group by

  M.NAME

order by

  `PERCENT_PATCHED`, M.NAME

Bottom line is I want to be able to get a patching report for machines in a label, reporting just on the patches in a specific patching schedule. I know little about SQL queries as this is my first real attempt at it. TIA for any help.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: JasonEgg 2 months ago
Red Belt
0

Weird: it works for me if I copy/paste your query and put in a relevant device label. How is it not working for you?

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