/build/static/layout/Breadcrumb_cap_w.png
06/17/2015 1995 views

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


All 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

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

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

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
Third Degree Green Belt

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