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!

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
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


  • John has also posted a great blog on SQL
    • You have NO idea how awesome you are!!!! Thank you so much!!
Please log in to comment