Workstation/Server Detected

Workstation/Server Detected



SELECT Max(workstation.workstationname) "Workstation", 
       Max(workstation.model)           "Model", 
       Max(workstation.servicetag)      "Service Tag", 
       Max(state.displaystate)          "Asset State", 
       Max(osinfo.osname)               "OS", 
       Max(aaauser.first_name)          "User", 
       Max(deptDef.deptname)            "Department", 
       Max(aaov.NAME)                   "Site" FROM   systeminfo workstation 
       LEFT JOIN resources resource 
              ON workstation.workstationid = resource.resourceid 
       LEFT JOIN resourcestate state 
              ON resource.resourcestateid = state.resourcestateid 
       LEFT JOIN resourceowner rOwner 
              ON resource.resourceid = rOwner.resourceid 
       LEFT JOIN resourceassociation rToAsset 
              ON rOwner.resourceownerid = rToAsset.resourceownerid 
       LEFT JOIN departmentdefinition deptDef 
              ON rOwner.deptid = deptDef.deptid 
       LEFT JOIN sduser sdUser 
              ON rOwner.userid = sduser.userid 
       LEFT JOIN aaauser aaaUser 
              ON sduser.userid = aaauser.user_id 
       LEFT JOIN resourcelocation resLocation 
              ON resource.resourceid = resLocation.resourceid 
       LEFT JOIN sitedefinition siteDef 
              ON resLocation.siteid = siteDef.siteid 
       LEFT JOIN sdorganization aaov 
              ON siteDef.siteid = aaov.org_id 
       LEFT JOIN osinfo osInfo 
              ON workstation.workstationid = osinfo.workstationid 
GROUP  BY workstation.workstationid 


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • Workstation Server Inventoried

                      SELECT Max(workstation.workstationname) "Workstation",         Max(workstation.model)           "Model",         Max(workstation.servicetag)      "Service Tag",         Max(state.displaystate)          "Asset State",  ...
                    • Report on User accounts stored in a Workstation\Server

                      DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select si.WORKSTATIONNAME AS "WORKSTATION NAME", ua.USERNAME,ua.DOMAINNAME,ua.FULLNAME,ua.DESCRIPTION,ua.STATUS,ua.LOCALACCOUNT,ua.SID, si.model AS "MODEL",si.servicetag AS ...
                    • SQL Server High CPU - To collect queries consuming CPU resources

                      1. To get an idea of how much CPU the queries are currently using, out of overall CPU capacity, run the following statement: DECLARE @init_sum_cpu_time int, @utilizedCpuCount int --get CPU count used by SQL Server SELECT @utilizedCpuCount = COUNT( * ...
                    • How to migrate ServiceDesk Plus from one server to another

                      Following are the steps to move data from the existing server to a new server, Step 1: Stop ManageEngine ServiceDesk Plus service. Step 2: Kindly Upgrade ServiceDesk Plus if required. Refer to the link below to check if you are in the latest version, ...
                    • Workstation and installed software

                      SELECT systeminfo.workstationname    "Workstation",         ( softwarelist.softwarename ) "Software_Name",         Max(swmfg.NAME)               "Manufacturer",         Max(softwareinfo.fileversion) "Version" FROM   softwareinfo  ...