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

ddaffy
Kilo Contributor

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?

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

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.


View solution in original post

6 REPLIES 6

jasonjones
Giga Contributor

Any documentation on best practices for creating the "Asset  Log" Table?  

 

Jason

Hi,

Just wanted to reply to see if any documentation was discovered or created regarding the creation of an Asset Log Table?

Matt