Doesn't anybody know or have the data dictionary for K1 Database?

I need to find all the PK's and FK's to build better SQL to find all the relationships for the tables.

Thanks!

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

Answers

1
This might help... It's not exactly what you're looking for and from the looks of it from an older version but it helped me out when trying to create all my ticket rules.

Answered 12/09/2014 by: h2opolo25
Red Belt

  • Thats great but its missing the asset tables.
  • Its also missing the PK and FK relationships which is needed to understand tables.
Please log in to comment
1
you can download Toad for mysql and hook that into your kbox and that will let you explore all the tables in it.

http://www.toadworld.com/m/freeware/default.aspx

and search google to find many good articles on connecting to the kbox

https://www.google.com/search?q=kace+k1000+sql+password&rls=com.microsoft:en-US&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&gws_rd=ssl#rls=com.microsoft:en-US&q=kace+k1000+connect+to+sql+database

Answered 12/09/2014 by: SMal.tmcc
Red Belt

  • already connected need the PK and FK relationships
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share