/build/static/layout/Breadcrumb_cap_w.png

Data Dictionary for K1 Database

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!

Asked 9 years ago 7631 views
0 Comments   [ + ] Show comments

Answers (3)

Posted by: h2opolo25 9 years ago
Red Belt
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.

Comments:
  • Thats great but its missing the asset tables. - mikesharp1 9 years ago
  • Its also missing the PK and FK relationships which is needed to understand tables. - mikesharp1 9 years ago
Posted by: SMal.tmcc 9 years ago
Red Belt
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

Comments:
  • already connected need the PK and FK relationships - mikesharp1 9 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ