Scenario: a laptop has been used by multiple people since it was purchased - we have assigned it to a user, then back in the storeroom, then assigned it to another user, then back in the storeroom and now it is with another user.

I know I can look at the 'HISTORY' tab on the asset and review all of the users but I need to be able to do this in a report/search.

Search/report 1: search for a user by name and it will show me all of the assets that were assigned to this user over time.

Search/report 2: search for an asset by serial number/asset number and it will show me all of the users that have been assigned this asset over time.

Thanks