Report on User accounts stored in a Workstation\Server

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?

        Resources

            • 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",  ...
            • 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 ...
            • Software Compliance Report

              Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...