SELECT MAX(WORKSTATION.WORKSTATIONNAME) AS "Machine Name",

        MAX(WORKSTATION.SERVICETAG) AS "Service Tag",

MAX(WORKSTATION.MANUFACTURER) AS "Manufacturer",

MAX(WORKSTATION.MODEL) AS "Model",

MAX(WORKSTATION. BIOSVERSION) AS "Bios Version",

MAX(WORKSTATION.BIOSDATE) AS "Bios Date",

MAX(STATE.DISPLAYSTATE) AS "Asset State",

MAX(DEPTDEF.DEPTNAME) AS "Department",

MAX(OSINFO.OSNAME) AS "OS",

MAX(PROCINFO.PROCESSORCOUNT) AS "Processor Count",

MAX(PROCINFO.SPEED) AS "Processor Speed (in MHz)",

MAX(AAOV.NAME) AS "Site"

FROM SYSTEMINFO WORKSTATION

LEFT JOIN RESOURCES RESOURCE ON WORKSTATION.WORKSTATIONID = RESOURCE.RESOURCEID

LEFT JOIN RESOURCESTATE STATE ON RESOURCE.RESOURCESTATEID = STATE.RESOURCESTATEID

LEFT JOIN RESOURCEOWNER ROWNER ON RESOURCE.RESOURCEID = ROWNER.RESOURCEID

LEFT JOIN RESOURCEASSOCIATION RTOASSET ON ROWNER.RESOURCEOWNERID = RTOASSET.RESOURCEOWNERID

LEFT JOIN DEPARTMENTDEFINITION DEPTDEF ON ROWNER.DEPTID = DEPTDEF.DEPTID

LEFT JOIN RESOURCELOCATION RESLOCATION ON RESOURCE.RESOURCEID = RESLOCATION.RESOURCEID

LEFT JOIN SITEDEFINITION SITEDEF ON RESLOCATION.SITEID = SITEDEF.SITEID

LEFT JOIN SDORGANIZATION AAOV ON SITEDEF.SITEID = AAOV.ORG_ID

LEFT JOIN BARCODES BARCODES ON RESOURCE.BARCODEID = BARCODES.BARCODEID

LEFT JOIN OSINFO OSINFO ON WORKSTATION.WORKSTATIONID = OSINFO.WORKSTATIONID

LEFT JOIN PROCESSORINFO PROCINFO ON WORKSTATION.WORKSTATIONID = PROCINFO.WORKSTATIONID

GROUP BY WORKSTATION.WORKSTATIONID