/build/static/layout/Breadcrumb_cap_w.png

Kace Report showing the percentage amount of a group label being patched with MS monthly patching

Need assistance in generating a Kace SQL report to specifically give our company's management team SLA Stats of servers grouped together by a Smart Labels.


0 Comments   [ + ] Show comments

Answers (3)

Posted by: Hobbsy 2 years ago
Red Belt
0

So what do you really need in your report??

Is it the % of servers that have run a successful patch deployment in the last 30 days?

Is it the % of patches that are deployed to a group of servers??

Is it the % of members in a group that have an active patch deployment schedule assigned???


Posted by: Jpadilla2020 2 years ago
White Belt
0

Is it the % of servers that have run a successful patch deployment in the last 30 days?

No, just needing at the stat of servers that are at least being attempted in patching weather it was successful or not as long as it attempting with Kace SMA. That is a positive stat for the org.

Is it the % of patches that are deployed to a group of servers??

I have 5 groups that each have their own Smart Label and regular labeling.

Is it the % of members in a group that have an active patch deployment schedule assigned???

Yes, each group of servers has their own patch label and schedule.

Posted by: Hobbsy 2 years ago
Red Belt
0

So here is some SQL to get you started

SELECT MACHINE.NAME,

       PATCH_SCHEDULE.DESCRIPTION,

       PATCH_SCHEDULE_MACHINE_STATUS.LAST_RUN

  FROM PATCH_SCHEDULE_MACHINE_STATUS PATCH_SCHEDULE_MACHINE_STATUS

        INNER JOIN PATCH_SCHEDULE PATCH_SCHEDULE

           ON (PATCH_SCHEDULE_MACHINE_STATUS.PATCH_SCHEDULE_ID =

                  PATCH_SCHEDULE.ID)

       INNER JOIN MACHINE MACHINE

          ON (MACHINE.ID = PATCH_SCHEDULE_MACHINE_STATUS.MACHINE_ID)

 WHERE TIMESTAMP(PATCH_SCHEDULE_MACHINE_STATUS.LAST_RUN) <= DATE_SUB(NOW(),INTERVAL 7 DAY) AND PATCH_SCHEDULE_MACHINE_STATUS.PATCH_SCHEDULE_ID = 3

 If you identify the schedule that was run and use the ID in the last line. Also you could consider adding in a label so that you would add to the where statement where the id is a member of a label.


 
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