/build/static/layout/Breadcrumb_cap_w.png

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.


Thanks!!!



0 Comments   [ + ] Show comments

Answers (2)

Posted by: chucksteel 5 years ago
Red Belt
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.



Posted by: Channeler 5 years ago
Red Belt
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?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ