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]

Hi David,

Try creating the db view using following conditions:

[David232]

Hey Shaurya,

Thanks for the help so far! I created the db view and it has solved half of my requirement, I can now see the 'Asset Tag' column when reporting off of this DB view.

Do you have any recommendations on how I could get display values for reference fields to show in the 'old/new value' fields. Here is what I am getting now when reporting off the DB view I created:

[TheJoeDC]

Yeah, the challenge is that sys_audit table doesn't have a reference to the user table, so you would need to build the view I think. 

This is an example that you could apply:

Example left join in creating a database view

[Community Alums]

Hey @David232 👋 

Yes, this is possible in ServiceNow. Here's a quick approach:

1. Enable auditing on key fields in the asset table (e.g., alm_hardware)

2. Create a report on sys_audit for changes in the last 7 days.

3. Create another report for new assets (created in the last 7 days).

4. Optionally, use a dashboard to show both reports.

5. Schedule a weekly report to email stakeholders.

If my response proves useful, please consider clicking "Accept as Solution" and marking it as "Helpful." This helps both the community and me!

Best Regards, 

Harshad Mule.  !!!