Hardware Asset changes report

[David232]

Hello!

We are wanting to use the Asset module in Servicenow to start tracking our hardware assets, but one of the business requirements is that we have a scheduled weekly report that gets sent to various individuals of any changes made or new assets added.

Our hardware assets are currently being tracked in an Access database that has this capability to show old/new field values and export them in a weekly report.

Has anyone set up something similar or can think of any way to accomplish this? Appreciate any ideas/help as I have hit a wall on this one.

[Shaurya Jyoti]

You can try creating a report on changes made to hardware assets:

• Table: sys_audit

• Filter by:

  • Document Table is alm_hardware

  • Created on last 7 days

Ensure audit is enabled for the alm_hardware table

[David232]

Hi Shaurya,

This was my initial thought as well so I explored it a bit already. The problem I ran into with this is when pulling from the sys_audit table I could not find a way to identify which hardware asset was being changed as it only provides a sys_id for the record being changed. Any suggestions on how to identify which record is being shown in the sys_audit table? 

[Shaurya Jyoti]

Hi David232,

You can try creating a database view between the alm_hardware table and the audit table. This way you can have a column displaying the sys_id and a column displaying the concerned hardware asset.

[David232]

Thanks Shaurya, 

Database views are not something I am familiar with yet. I will look into it and see what I can learn/create. Any specifics on how to accomplish what I am needing with a database view would be a great help.

Image below is a basic report I created on the sys_audit table showing assigning an unassigned asset to a specific user. From the report I do not have a way to identify which asset it was that got assigned, and the assigned to value is showing as sys_id rather than the person's name. These are the 2 problems I must solve for so I can send out a report to the various employees that need this info.