Build SQL Reports
Guys ,
I'm trying to build reports from my KACE box. Is there a list of tables and columns with sql id/password so I can being testing?
0 Comments
[ + ] Show comments
Answers (5)
Please log in to answer
Posted by:
FergieMan
9 years ago
I've created the Odbc connection but I cannot log in using MySQL workbench. What is the port I should use?
Posted by:
FergieMan
9 years ago
Im trying to connect into MySQL workbench , but it fails to log on. I have all the correct information in terms of passwords etc
Posted by:
FergieMan
9 years ago
I can't log into Kace 1000 with MySQL workbench. It tells me the password isn't correct but I can create and odbc connection and connect into the d/b via excel. Strange? Any see this before?
Posted by:
Druis
9 years ago
You should have a Read account in Kace. If you use something like Heidi or MySQL workbench you will be able to look at the tables
Posted by:
Hobbsy
9 years ago
You can set up an ODBC connection, you will need a mysql 64bit driver to set up the data source
Try from here https://dev.mysql.com/downloads/connector/odbc/
Once you have this installed you need to set up the connection
For default settings the DB is ORG1
The user is R1
and the default p'word is usually box747 although you should probably reset this within the settings>General Settings area of your K1
Once you have configured the connection you will be able to see all of the tables etc