Index of SQL Reporting Building Commands/Syntax

Is there a general index out there anywhere which lists all the different SQL commands which can be used for building custom reports, and what they correspond to in KACE? I have seen several custom reports, but I am having trouble inferring from them which commands correspond to what items, especially when you have a bunch of = commands, meaning that one command depends on another value. Thanks.

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: chucksteel 2 years ago
Red Belt

Top Answer

The basic answer is, no, not really.

The KACE appliances run MariaDB in the backend, which is very much like MySQL, so training resources are easy to find. MariaDB does have their own tutorial information here:


As far as how things correspond to the KACE database structure, the best way to understand it is to setup something like MySQL Workbench and connect to the DB using the reporting user. It's very well laid out and generally easy to follow links from one table to another. 

Specific questions are always welcome, too. Good luck on your journey.

  • Thanks for the reply. I did install the MySQL Workbench on my VM, and tried to connect our K1000 to it, but was not sure of the parameters. In workbench, it default the port to 3306. Do you know if that is the port that the K1000 would connect through?) Maybe this is set by our organization.) - jmorton 2 years ago
    • Did you configure Offboard Database access (see Settings, Security Settings). - chucksteel 2 years ago
      • No I had not, but I found the setting you are talking about. Thanks. - jmorton 2 years ago
      • I now have KACE configured to do the offbox reporting, and have the database opened up in MySQL. However, every time I am trying to test the sql command set up, it is giving the error of "Error Code: 1142. SELECT command denied to user '[reporting user]'@'[computer name]' for table 'PATCHLINK_MACHINE_STATUS'"

        I noticed that when I test the connection from MySQL to KACE, if I fill in ORG as the default schema, it then says "Failed to connect to MySQL at [servername]:3306 with user [reporting user] Access denied for user '[reporting user]@'%' to database 'ORG'

        Any thoughts? - jmorton 2 years ago
      • The reporting user should be R1 with the default schema of ORG1. - chucksteel 2 years ago

Don't be a Stranger!

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

Sign up! or login


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