I need a report that will give me the ownership changes of our assets for a given timeframe.  Some examples of the data I'm looking for in the report are if a pc is assigned to someone last week, I want that to show on the report for that week.  If a pc is reassigned to another user, I'd like to see that show up on the report.  I need these fields:

 

Model

Asset Tag

Serial Number

Resource State (DISPLAYSTATE, not RESOURCESTATEID)

Previous Owner

New Owner

 

Parameters:

To/From Dates