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 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 ...