report of asset for instock to inuse state change

[nidhiKurmi]

Hi. I am trying to create a report which will give me list of assets which were in instock status and later changed to in use. we are trying to get cost optimization report for assets. we need to get list of all assets which were in stock earlier and then assigned to some user resulting in state change to in use.

[Mark Manders]

It depends what data you store. It's never a good idea to report on the sys_audit table.
The issue is that you have an 'assigned' date on alm_asset, but it doesn't specify what the earlier status was. Maybe it went from 'in order' to 'in use' or even from 'in use' to 'in use'.
If this is not something you are already tracking, you could create a custom field for it or you can utilize metrics.