KACE Product Support Question
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.
Community Chosen Answer
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.