Does a database schema exists for K1000 6.0 ?
Hi everyone,
I'm looking for the K1000 6.0 database schema.
Where can I find it ?
Thank you in advance
Answers (4)
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
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.
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
