Is there a Kace 1000 database design
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.
Community Chosen Answer
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>