/build/static/layout/Breadcrumb_cap_w.png

In depth K1000 Schema

I am able to connect to the database and after viewing the tables and the data in them but in order to be able to write queries for internal reporting I need more information regarding the schema. It would be extremely helpful to know what each table/column stand for and relationship between tables, i.e., the “id” column. Can anyone provide this info. The admin guide didnt really help me as much as I would have hoped!

Asked 11 years ago 6775 views
0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
http://www.kace.com/~/media/Files/Support/KACE-Konference/2011/US/Custom-SQL-Reporting-and-the-K1000-Database.ashx http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example
Posted by: SMal.tmcc 11 years ago
Red Belt
2

http://www.kace.com/~/media/Files/Support/KACE-Konference/2011/US/Custom-SQL-Reporting-and-the-K1000-Database.ashx

Comments:
  • John has also posted a great blog on SQL
    http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example - SMal.tmcc 11 years ago
    • You have NO idea how awesome you are!!!! Thank you so much!! - cwest311 11 years ago

Posted by:

cwest311 Second Degree Blue Belt
Ninja since: 11 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:

KACE Product Support Questions
question

Related Questions

Link

Related Links

Post

Related Posts

Share

 
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