Table Layout

I am trying to gain an overall understanding and location as to where everything is.  I was given the list of tables here, but not all of these tables are currently used.  I am having to select all from each table to get an idea as to what is stored.  Would anyone happen to have an easy to read definition of each table? 

0 Comments   [ + ] Show comments

Answers (3)

Posted by: chucksteel 3 years ago
Red Belt

Use a tool like MySQL Workbench to connect to the database with the reporting user. That will allow you to browse the tables and view their structure. The database doesn't use external keys, so it's not possible to create a schema with automated tools. In general, however, I have found it very easy to navigate and view the relationships between tables. For instance, the HD_TICKET table includes columns for HD_QUEUE_ID, HD_CATEGORY_ID and these correspond to the HD_QUEUE table's ID column and the HD_CATEGORY table's ID column respectively.

Posted by: duncant-wssu 2 years ago
White Belt

I was finally given a schema of the Database. 

Posted by: Hobbsy 3 years ago
Red Belt

KACE has never published a schema, probably for two reasons, first you would need to keep it up to date and publish it with every release and second, KACE was designed so that we as users never really get to see what’s under the hood. If you are facing a specific challenge whereby you would like to know what table connects to which, then just ask here in ITNinja and those of us with more experience will do our best to guide and explain.

  • It's more so comments on the tables. It would be easier to understand what data is contained in each table. - duncant-wssu 3 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


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