ITAM - Asset Never Used

Vaibhav Sharma1
Tera Contributor

Hi All,

 

I need to create a report for all the assets which are never used from asset creation date.

 

In other words, I need to filter out the assets which are In Stock from the date of creation.

2 REPLIES 2

Community Alums
Not applicable

Hi @Vaibhav Sharma1 ,

Do you have the audit enabled for alm_hardware table. If yes then you can use 

 

sys_history_set table and sys_history_line table to get the details.

 

However it is not the best practice to report on these tables, so I would suggest create a metric definition for the asset hardware table fields. I will capture any change in the future.

 

vinitha3
Tera Guru

Hi,

As you have mentioned, it is a straight forward report with filter "State is In Stock" and "Sub State as available".

you can also use the inactivity monitor to check whether the form has been touched or not for those assets in stock state.

Thanks,

Vinitha