Miscellaneous

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