Asset Activity Log

sharonjanisch · ‎01-21-2021

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 · ‎01-21-2021

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

View solution in original post

Sebastien C · ‎04-13-2023

Hi,

Here my need: I would like to know if a user has been assigned to an asset by the past.

I following your proposal but I don't see any any users, only a document key field. How I could do to watch a name of user or filter by a user?

Kr,

Sebastien