Custom Report to track Assets

Custom Report to track Assets

Hello,

I am trying to track wireless broadband cards as asset components and I need a report to show the current user and the contract dates in a single report. Can you send me a query to show the following information in the same report?

Asset/Resource
Asset Name, Product

Requester
The asset is associated to a workstation. I would like to see the requester name that is the user on that workstation (not the assigned to which is the workstation name)
I have 3 custom fields I would also like to show from the requester field:
Frequent Traveler (Text), EOC Broadband Approver (Text), EOC Broadband Approved (Date/Time)

Contract
From Date, To Date, Status

I would like this grouped by Product Type.

Is this possible?

Thank you!


















                    New to ADSelfService Plus?