Custom query report for workstation details

Custom query report for workstation details

Custom query report for the below workstation details

Name,
Service tag,
Model
Mac Address
Location
site
user
department

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


Thanks and regards,
Prasanna.


AssetExplorer Team
              New to ADManager Plus?

                New to ADSelfService Plus?