Asset Management - report to find the user accounts of workstations
SELECT workstation.workstationname "Workstation",
ua.username "User Name",
ua.domainname "Domain Name",
ua.description "Description",
ua.status "Status",
state.displaystate "Asset State" FROM usersaccountinfo ua
LEFT JOIN systeminfo workstation
ON ua.workstationid = workstation.workstationid
LEFT JOIN resources resource
ON workstation.workstationid = resource.resourceid
LEFT JOIN resourcestate state
ON resource.resourcestateid = state.resourcestateid order by 1
Click this link to navigate to the next report.