KACE Product Support

Welcome!

There are a lot of examples of patching reports on this site:

https://www.google.com/search?q=site%3Aitninja.com+patching+report&oq=site%3Aitninja.com+patching+report&aqs=chrome..69i57j69i58.8080j0j1&sourceid=chrome&ie=UTF-8

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:

https://github.com/csteelatgburg/K1000-Database-Queries

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).

https://support.quest.com/kace-systems-management-appliance/kb/131521/sma-how-to-make-a-query-into-a-report

SQL knowledge is needed to build the sentence, you can connect to the KACE Database with MySQL Workbench or Toad or Heidi SQL:
https://support.quest.com/kace-systems-management-appliance/kb/114992/can-i-access-the-k1000-appliance-database-using-a-third-party-reporting-tool-

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:

New to KACE Products or just inherited an SMA or SDA? Have a project or need something configured on the fly?