/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Data Dictionary for K1 Database

12/09/2014 7415 views

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



Community Chosen Answer

All 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.
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
 
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