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

Comments

Please log in to comment

Answers

0
I've created the Odbc connection but I cannot log in using MySQL workbench. What is the port I should use?
Answered 06/18/2015 by: FergieMan
Third Degree Green Belt

Please log in to comment
0
Im trying to connect into MySQL workbench , but it fails to log on. I have all the correct information in terms of passwords etc
Answered 06/18/2015 by: FergieMan
Third Degree Green Belt

Please log in to comment
0
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?
Answered 06/18/2015 by: FergieMan
Third Degree Green Belt

Please log in to comment
0
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
Answered 06/17/2015 by: Druis
Blue Belt

Please log in to comment
0
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
Answered 06/17/2015 by: Hobbsy
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity