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", ...Unauthorized Access CSV Report for Users Not Present in the Application
Report Details: Currently, the application has not been recording data regarding login attempts when the username used is not available in the application. This report will store the login attempts with usernames who do not exist in the application. ...ADMP Integration - How to automate unlocking of user accounts in Active Directory
This post described the use of a python script to automate unlocking of user accounts from request. This script can be configured under Request custom triggers and you will find more information about this here. Integrating ServiceDesk Plus with ...Report on Organizational roles
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select r.orgrolename "orgrolename", r.description "Description", au.FIRST_NAME "Name", DepartmentDefinition.DEPTNAME "Department", SDOrganization.NAME "Site" from aaauser au ...