How to create a report on history of All assets (alm_hardware) ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2022 08:59 AM
Hi There,
I need to create a report on history of all assets from 'alm_hardware' table.
I need to see the history of assets. Example : User got a new laptop in 2019, left the company, turned their laptop back in and then we gave that laptop to someone else. I need to see that history details in report.
Please help me for making this report in ServiceNow.
Really appreciate your quick response!!
Thanks,
Audumbar Kamble
- 1,302 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2022 09:33 AM
Hello,
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.
Please mark my answer as correct based on Impact.