12/05/2018 80 views

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


All Answers


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.

Answered 12/06/2018 by: chucksteel
Red Belt

  • 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.)
    • Did you configure Offboard Database access (see Settings, Security Settings).
      • No I had not, but I found the setting you are talking about. Thanks.