KACE Product Support Question

Need SQL Query for Report

04/26/2017 395 views

Can someone please give me a SQL query to copy/paste? I need a simple report that shows me

"# of PCs Patched in Compliance"

"# of PCs Patched Not in Compliance"

"# of PCs with Errors"

Preferably these would be links to the computers in each category. If this cannot be done, I need the name of the SQL instance so maybe our SQL people could try.

Thank you in advance!

0 Comments   [ + ] Show comments


All Answers

How is the desired information different from the details in Security > Catalog ? In that view I can see patch name, # installed, # missing, # with errors, and compliance %. It also has something a SQL query can't do (which you request): the numbers are links to a list of the applicable computers.
Answered 04/27/2017 by: JasonEgg
Red Belt


I don't need to see the list of available patches. I just need to see:

# PCs in Compliance        #PCs out of Compliance       

Answered 04/27/2017 by: SixStringHurricane
White Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


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