Asset Activity Log

[sharonjanisch]

Is it possible to do a report of the Activity logs in Assets.  One of our managers wants to know all assets that were ever assigned to a user.   There is a question of whether a computer was returned and then reassigned to someone else.    Any suggestions would be appreciated.  Thanks.

[Akshatha Ballal · Accepted solution]

One of the ways of doing it is going to sys_audit table, filter only the asset table ( Target table contains the table you want to search) and then you can export the result and analyze the activity of deletion, creation/reassignment.

For example, I assigned a hardware asset to myself in my instance. So, I searched with that table name, alm_hardware and tracked the changes of assigned_to field on a particular day.

Your particular use case is dealing with changes to a reference field i.e assigned to. Please refer the following link to get some idea on how the update on a reference field is tracked.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/security/concept/c_TrackingChangesToReferenceFields.html

[sharonjanisch]

That's exactly what I needed.  Thank you!

[Akshatha Ballal]

You're welcome.

[Andy Bishop]

New to looking through tables. I suppose it is possible in our instance I do not have access to the sys_audit table.

but

how do you get to the screen which you showed here, showing the SYS AUDITS to then apply filters?