Report on assets previously assigned to a user

[Jon Collins2]

Hi Folks,

Is there a straight forward way to look up or query assets (laptops) previously assigned to a specific user? These assets may be retired or repurposed now, but we're attempting to list all laptops that at any point in time were assigned to a specific user in question. 

Thanks in advance!

[Sai Kumar B]

@Jon Collins 

If Audit is enabled on your table you can find history related to your asset record in 'sys_audit' table

[Ankur Bawiskar · Accepted solution]

@Jon Collins 

Is the table audited?

If yes then you can check the history table for this -> sys_history_line and sys_history_set

If the table is not audited then it's not possible

Regards
Ankur

[Jon Collins2]

Thanks Ankur, we did not have auditing enabled on this table. I appreciate the help. 

[Joe Ryder]

This is crazy to me that ServiceNow and several other platforms don't have asset assignment history records and have users rely on history logs. There are so many other things that need to be captured during assignment and reclamation to feed trend reporting that may change over time, such as the department the user is part of at the time of the actions. It seems the answer is always, "Create an app that does this".

I could absolutely see the flow of an Asset Reclamation History record that tracks all the data around the person from which the asset was reclaimed, static with a timestamp, as well as an Asset Assignment History record that tracks all the data around the person assigned to the asset, again static with a timestamp. This table or tables is then reportable for trends of new assets assigned in a specific location or department, as well as trends of reclamations in a given location or department. It can even include calculations of time between employee end date and reclamation date, which is invaluable to ITAD.

If that's not on ServiceNow's roadmap, it should be. Time to check the idea forum, I guess...