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)
I also posted a blog today with some reports that may help:
http://www.itninja.com/blog/view/k1000-reports-patching-reports-for-completion-by-patch-machine-vendor-using-labels
John
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
