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.
Answers (3)
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???
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.
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.