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 ...
            • Workstation and installed softwares

              SELECT systeminfo.workstationname    "Workstation",         ( softwarelist.softwarename ) "Software_Name",         Max(swmfg.NAME)               "Manufacturer",         Max(softwareinfo.fileversion) "Version" FROM   softwareinfo  ...
            • Out-of-Office emails are not detected as auto-generated mail

              Out-of-office automated reply mails are not detected as auto-generated emails, so requests are getting reopened. This issue occurs due to the case-sensitive check done internally to retrieve the header "Auto-submitted" from the mail but the mail ...
            • 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, ...