How to create a report on history of All assets (alm_hardware) ?

Audumbar Kambl1
Tera Contributor

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 REPLY 1

Saurav11
Kilo Patron
Kilo Patron

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.