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!
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
SMal.tmcc
10 years ago
you can google that. John has some very good blogs on this.
https://www.google.com/search?q=pk+and+fk+kace+k1000+sql&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=fflb
http://www.itninja.com/blog/view/k1000-reports-k1000-database-keys-relationship-matrix-queries
https://www.google.com/search?q=pk+and+fk+kace+k1000+sql&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=fflb
http://www.itninja.com/blog/view/k1000-reports-k1000-database-keys-relationship-matrix-queries
Posted by:
h2opolo25
10 years ago
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 10 years ago
-
Its also missing the PK and FK relationships which is needed to understand tables. - mikesharp1 10 years ago
Posted by:
SMal.tmcc
10 years ago
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
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 10 years ago