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!

[Scott Halverso1]

Great idea!  We've been submitting ideas to ServiceNow to bring a consumer grade My Assets feature to ServiceNow.  To me this is an extension of that vision.  Similar to what has been done on the mobile, but with the addition of being able to take action, such as giving a launching place for the user to attest that they still have the device/software.  And to your point a place to see a history of the devices/software they've had.  As Ankur pointed out there is nothing in the system other than looking at audit logs of the asset to see the audit log of the value of the assigned to field.  Reporting on those tables is against best practice for fear of creating performance issues.