KACE Report number of patches not installed by machine
We'd like to view a report similar to what WSUS can generate that shows machine names and how many patches are not installed to quickly view what systems would be out of compliance.
Answers (2)
You could try the SQL reports I have listed in this article (or modify them to suit your needs):
K1000 Patching - Setup, Tips & Things I Have Learned (LDAP, Smart Labels, SQL Reports)
http://www.itninja.com/blog/view/k1000-patching-setup-tips-things-i-have-learned-ldap-smart-labels-sql-reports
If you need help getting started with SQL, try this:
Primer for Writing SQL Select Statement Queries on the K1000 (w/Custom SQL Report example)
http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example
John