How to create custom report
I inherited the KACE management recently when a member of our team left. I would like to create a report that shows the results of patching. For example a label called "January 2019" that's assigned to a smart label call "servers". I need to see if they were successful.
There are a lot of examples of patching reports on this site:
For your request I would recommend this post: https://www.itninja.com/question/patch-report-request
I also maintain a collection of SQL queries here:
If you can't find what you need, there are folks here that are happy to help.
As Channeler said, setting up MySQL Workbench or a similar tool is highly recommended. The database is fairly well laid out and easy to follow from one table to another.
You will need a SQL report, because the Wizard is unable to pull data from two tables (Patches vs. Devices).
SQL knowledge is needed to build the sentence, you can connect to the KACE Database with MySQL Workbench or Toad or Heidi SQL:
I recommend you pull backups first or use a Sandbox appliance, since a bad SQL query may render the Appliance unstable.
If you are new to KACE please read this: