Hi everyone,

 

I'm looking for the K1000 6.0 database schema.

 

Where can I find it ?

 

Thank you in advance

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

You can get the Table names and the related Component in Appendix D of the Administrator Guide.  If you are looking for field definitions or ERDs, I haven't seen any.

http://www.kace.com/support/resources/documentation

 

 

Answered 06/06/2014 by: grayematter
Fourth Degree Black Belt

Please log in to comment
0

KACE tried to provide one many many years ago but didn't work out so they stopped. There isn't anything today that will show the schema other than connecting to the db with a 3rd party tool or as Grayematter indicated, the appendix in the back of the admin guide. 

Answered 06/09/2014 by: nshah
Red Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

0

Hi, I've found this some time ago...its not for 6.0 but maybe it can help you.

http://www.kace.com/~/media/Files/Support/KACE-Konference/2011/US/Custom-SQL-Reporting-and-the-K1000-Database.pdf

Answered 06/10/2014 by: dlistar
Second Degree Blue Belt

Please log in to comment
0
DListar is correct and that PDF is valid in steps to take.  Many customers use MySQL Workbench to see that tables and it is a handy tool to use.  We have a KB article available but I noticed a link within it is dead as we move to our new Knowledge Base and I will be updating it.  Does your K1000 have orgs enabled?
Answered 06/11/2014 by: KACE_Mary
Red Belt

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