Look up user and find assets currently/previously assigned to user

[ddaffy]

Is it possible, ex. via a report, within ServiceNow Geneva to look up a user and view assets (ex. laptops) that are currently and/or previously (historically) assigned to the user?   If so, how would this be done?   Is it possible to do this out of the box with no ServiceNow customization?

[Chuck Tomasi · Accepted solution]

Hi Dan,

The current Asset list can be found by viewing the assigned_to field on the alm_asset table.

Getting previous history is not available OOB. You would need to create a "asset log" table of your own and update it over time with a business rule as the assigned_to field changes on alm_asset. That log table would then become your source.

[ddaffy]

Thank you Chuck!   This was helpful feedback for me!!

[Chuck Tomasi]

Hi Dan,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you

[ddaffy]

Hello Chuck,

I marked your answer as correct.   Thanks again!

Sincerely,

Dan Dafler