I have 70 different Asset types. I have different assets associated in each of these asset types.

Is there a master table which tells which user has what asset? I am also looking to find all assets entered by our inventory manager in KACE between Jan 1-2012 and Nov 1, 2012

If not, I am looking for a KACE 1000 database design which might help me with my question.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4

There isn't a database design available per se. I also don't think the audit trail will tell you what person entered inventory, but I could be wrong on that.

There is an older schema for version 5.2 located here: http://downloads.kace.com/support/customer/release/K1000/5.2.38773/k1000_server_5.2.38773_org.schema

You can also get the schema in MySQL Workbench by using:

 

show tables; desc <TABLE_NAME>

 

Answered 11/13/2012 by: jknox
Red Belt

Please log in to comment

Answers

0

Thanks jknox. 

If there a way for me to know which table has a primary to foreign key relationship? Is there any way for me to know that these columns from these tables when joined together will give me x as an output based on my original query?

Answered 11/13/2012 by: nainil.ecw
Senior White Belt

Please log in to comment
0

Open the schema in a text editor and look for the lines that define the primary keys like the following from the table DELL_MACHINE_PKG_UPDATE_STATUS

 PRIMARY KEY (`MACHINE_ID`,`CATALOG_ID`,`PACKAGE_DID`)

If you search the rest of the file for these key names you will notice in every table they are defined as either a key or primary key for that table so they have a relationship everyhwere that they occur.

 This may also help though it is a bit older.

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

 

Answered 11/28/2012 by: jdornan
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity