KACE Product Support Question
Patching Report - SQL Statement Needed using Smart Label for Patches against schedules and machine smart label
07/18/2017 953 views
KACE 1000 version 6.4.120822
Maybe I'm doing this wrong and there's a better way. If so I'm interested.
I'm currently using a smart label when patching a group of servers to filter patches by the OS and up to a certain date. This allows a test servers group to be patched with everything up to a certain date and the smart label is applied against the schedules for the production servers, so they get the same 'tested/approved' patches.
When a schedule is created the machines patches are determined by the smart label. After patching I'd like to get 2 reports, one that shows compliance of the servers in the schedule to the patches that were applied to them in the last deployment. Essentially a True/False next to each server in the targeted schedule with whether it got all the patches or not from the Smart Label.
The other report I'd like to get is a list of all the nonpatched patches in the smart label with a list of the servers missing the patch. I want to filter the search against machines by matching the OS to the smart label or by using machine smart label that is filtering out by OS.
I've dug through the site and seen how to call a label name against machines in a report but am not having any luck with finding hot to build a report that limits the patches listed by the patching smart label.
Be the first to answer this question