ITAM - Asset Never Used
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2024 11:42 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2024 01:31 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2024 09:09 AM
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