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 "Service Tag",max(net.macaddress) "MAC ADDRESS",MAX(regionDef.REGIONNAME) AS "Region", MAX(deptDef.DEPTNAME) AS "Department", MAX(aaov.NAME) AS "Site", MAX(resLocation.LOCATION) AS "Location" from UsersAccountInfo ua full join SystemInfo si on si.WORKSTATIONID = ua.WORKSTATIONID left join networkinfo net on ua.WORKSTATIONID=net.WORKSTATIONID LEFT JOIN Resources resource ON si.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN RegionDefinition regionDef ON resLocation.REGIONID=regionDef.REGIONID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID group by si.WORKSTATIONNAME,si.model,si.servicetag,ua.USERNAME,ua.DOMAINNAME,ua.FULLNAME,ua.DESCRIPTION,ua.STATUS,ua.LOCALACCOUNT,ua.SID order by 1
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", ...Workstation/Server Detected
SELECT Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(workstation.servicetag) "Service Tag", Max(state.displaystate) "Asset State", ...Query to find out who created Accounts (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down ...Query to get the user details (both technicians and requesters) account-wise with User ID (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) Tested in builds : 14000, 14201, 14301 1) Query to get the First Name, Last Name, Display Name, Login User ID, Login Name, Email and Phone Number of all users in the application, account-wise, with the ...user does not have sufficient privilege
Found below error in the logs U13:26:20:252]|[05-07-2021]|[com.manageengine.zrmeinteg.framework.ZRSDPFrameWorkImpl]|[INFO]|[6950]: Server Exception in getting shared user and licence details ::: | ServerException (HttpStatusCode 403 Error Code: 7301 ...