/build/static/layout/Breadcrumb_cap_w.png

K1000 - Exporting/Reporting Assets with Record Created date

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

Answers (1)

Posted by: Hobbsy 9 years ago
Red Belt
0

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

Select

ASSET_HISTORY.ASSET_ID

ASSET_HISTORY.NAME

ASSET_HISTORY.TIME

ASSET_HISTORY.CHANGE_TYPE

where

ASSET_HISTORY.CHANGE_TYPE = "Creation"

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

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