Full Workstation Report

Full Workstation Report

Good Day,

please can someone help me with a query...

I need to import workstations via csv into SD7.

first I need to eport the current Asset/Workstation/Resources (Workstations) the problem I am having is none of the std reports dor workstations extracts the Serial number of the workstation, please can someone help me with a query to export the following details...

Workstation Name
Model
Service Tag
Manufacturer
OS
Asset Tag (Same as Service Tag)
Asset Serial Number (This is the problem child)
Assigned to User

I need this in tabular format to export to csv, change details and then either delete all the assets, and reimport, or import and over write...

Please Assist
Thank You
Warren