/build/static/layout/Breadcrumb_cap_w.png

Weekly Patch Report

BpSmu1.jpeg
I just completed setting up my patch schedule for all of my workstations and I would like to create a weekly recap of all my patches for the week.  In my Patch Schedules Screen I see all of my patch label schedules and I like the recap at the end which shows which workstation has completed and what workstations failed.  I can drill down further on the report to see which workstations were successful and which were not.  I would like to capture that setup in a weekly report and emailed to me on a weekly basis so I can review and further troubleshoot my workstations.  I am overwhelmed on which one to pick but looking through the different samples I see the variation but cannot fine tune or customize the same look that I get from my KACE Patch Schedule Screen.  Any help would be greatly appreciated.  Thanks.


Asked 7 years ago 729 views
1 Comment   [ + ] Show comment
  • Which report included with the appliance is closest to what you want and what changes would you like to see? - chucksteel 7 years ago

Answers (1)

Posted by: Hobbsy 7 years ago
Red Belt
1
You can export that view into a report and the SQL looks a little like this,

SELECT (CASE

                   WHEN PBC.PATCHES_DISABLED = PBC.PATCHES_TOTAL THEN 'Disabled'

                   WHEN PBC.PATCHES_INACTIVE = PBC.PATCHES_TOTAL THEN 'Inactive'

                   WHEN PBC.PATCHES_ACTIVE = PBC.PATCHES_TOTAL THEN 'Active'

                   WHEN PBC.PATCHES_ACTIVE != PBC.PATCHES_TOTAL THEN

                       concat('Active (',PBC.PATCHES_ACTIVE,' of ',PBC.PATCHES_TOTAL,')')

                    ELSE 'Active'

                   END) AS PATCH_STATUS, PB.IDENTIFIER as Package, PB.TITLE as 'Name',PB.RELEASEDATE AS 'Released', PB.VENDOR AS 'Publisher', (CASE PB.TYPE WHEN 1THEN 'Security' WHEN 0 THEN 'Non-Security' WHEN 2 THEN 'SOFTWARE' ELSE '' END)AS TYPE, (CASE PB.IMPACTID WHEN 'Critical' THEN 'Critical' WHEN 'Critical - 01'THEN 'Old Critical'

                                           WHEN'Critical - 05' THEN 'Superseded'  WHEN'Recommended' THEN 'Recommended' ELSE '' END) AS Impact, PB.SEVERITY asVENDOR_SEVERITY, PB.REBOOT as REBOOT, PBC.COMPLIANCE AS COMPLIANCE, PBC.PATCHEDAS INSTALLED, PBC.UNPATCHED AS MISSING, PBC.ERROR AS ERROR, PBC.CACHE_SIZE asSize, (CASE

                                WHENPBC.PATCHES_SUPERCEDED = 0 THEN 'No'

                                WHENPBC.PATCHES_SUPERCEDED = PBC.PATCHES_TOTAL THEN 'Yes'

                                WHENPBC.PATCHES_SUPERCEDED != PBC.PATCHES_TOTAL

                                    THENconcat('Yes (', PBC.PATCHES_SUPERCEDED, ' of ',PBC.PATCHES_TOTAL,')')

                                END) ASIS_SUPERCEDED FROM KBSYS.PATCHLINK_BULLETIN PB

                INNERJOIN KBSYS.PATCHLINK_IMPACT I ON I.IMPACT = PB.IMPACTID

                LEFTJOIN PATCHLINK_BULLETIN_COUNT PBC ON PBC.BULLETIN_ID = PB.IDENTIFIER ANDPBC.PLATFORM_ID = PB.PLATFORM_ID WHERE (PBC.PATCHES_TOTAL!=0 AND PBC.PATCHES_DISABLED !=PBC.PATCHES_TOTAL)   order by COMPLIANCEdesc


Comments:
  • FYI this query omits some spaces. Maybe line breaks are to blame? - JasonEgg 7 years ago
 
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