Custom report listing all devices and detect status of all patches in a particular patch label

I am looking to create a custom report in KACE that lists all devices and the detection status of all patches that are in a particular patch label. For example, I have a patch label called "Approved OS Patches" which contains all of the patches that are currently approved for deployment. I want a report whose output looks similar to the following: Device Name, Patch Name, Detection Status Computer1, KB1234567 Patch one, PATCHED Computer1, KB2345678 Patch two, NOT PATCHED Computer2, KB1234567 Patch one, PATCHED Computer2, KB2345678 Patch two, PATCHED ...and so on. I have spend quite a lot of time with the wizard trying to come up with something and I am not able to create what I am looking for. Unfortunately, my SQL skills are not ideal, either. If anyone has had success creating something like this with the wizard or a SQL query, please share.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: mdickson@markandy.com 8 months ago
Senior White Belt

Hello, did you ever find a solution?

Posted by: mdickson@markandy.com 7 months ago
Senior White Belt

No I didn't. 

I'm playing with MYSQL an looking through the tables.

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