07/11/2014 3489 views
We are wanting to upgrade our K1000 to version 6 as soon as possible for various reasons.  The only thing holding us back is the fact that the asset creation and last modified dates are changed from their current dates (see http://www.kace.com/support/resources/kb/solutiondetail?sol=125811).

In order to work around this and upgrade, it was asked if we could either export all current assets or run a report to grab all assets and have the "Record Created" date included with all the other information. 

I have tried to make a custom report but I haven't seen a way to grab the "Record Created" date.  Any suggestions would be much appreciated!
0 Comments   [ + ] Show comments


All Answers


The data that you require is probably found in a different table, so for example if you wanted Computer Assets, the asset type is 5 so Asset_Data_5 would logically be the table where you think the data will be held, however.... If you look in the Asset_History table you will see the history record, i.e. every change for each asset listed, and the changes are listed against the Asset ID in ASSET_HISTORY.ASSET_ID field, if you look across to the CHANGE_TYPE column you will find a value of Creation and the associated data/time in the TIME column.

You can write a custom report that is based on the data within that table alone, although this cannot be done through the wizard option. It would be something like








My SQL is not good, but hopefully that gives you an idea

Answered 07/16/2014 by: Hobbsy
Red Belt