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.
Answers (1)
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.
Comments:
-
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 5 years ago
-
Did you configure Offboard Database access (see Settings, Security Settings). - chucksteel 5 years ago
-
No I had not, but I found the setting you are talking about. Thanks. - jmorton 5 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 5 years ago -
The reporting user should be R1 with the default schema of ORG1. - chucksteel 5 years ago
