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