/build/static/layout/Breadcrumb_cap_w.png
01/23/2019 580 views

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.


Thanks!!!


0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1

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.



Answered 01/24/2019 by: chucksteel
Red Belt

All Answers

0

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?

Answered 01/23/2019 by: Channeler
Red Belt