Asset Management - report to find the user accounts of workstations

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.