Workstation Server Inventoried

Workstation Server Inventoried

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 
       INNER JOIN lastauditinfo 
               ON workstation.workstationid = lastauditinfo.workstationid 
WHERE  ( lastauditinfo.last_success_auditid IS NOT NULL ) 
GROUP  BY workstation.workstationid 

        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • Workstation/Server Detected

              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  ...
            • 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, ...
            • Unable to start the server. On an error / any of the containers(modules) are failed

              Open the serverout0.txt found under [SDP-Home]\server\default\log using any text editor.  Search for the word 'Exception'. See if there are any known error pertaining to the environment. The most reported are due to 'Low disk space' in the drive. For ...