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