select max(si.workstationname) "Workstation", max(si.servicetag) "Service Tag", max(si.model) "Type", max(ni.macaddress) "Mac Address", max(sui.location) "Location" , max(dep.deptname) "Department", max(aaov.name) "Site", max(aaauser.first_name) "User" from systeminfo si
left join networkinfo ni on si.workstationid=ni.workstationid left join SystemUserInfo sui on sui.workstationid = si.workstationid left join resources res on res.resourceid = si.workstationid
left join resourceowner rown on rown.resourceid = res.resourceid
left join departmentdefinition dep on dep.deptid = rown.deptid
left join sduser sduser on rown.userid = sduser.userid
left join aaauser aaauser on sduser.userid = aaauser.user_id
left join resourcelocation reslocation on res.resourceid = reslocation.resourceid
left join sitedefinition sitedef on reslocation.siteid = sitedef.siteid
left join sdorganization aaov on sitedef.siteid = aaov.org_id
group by si.workstationid