Find All AD Users and Their Managers in Active Directory
Quickly find the manager belonging to each user without the need of any sort of manual Powershell scripting. Simply run a Lansweeper user scan and utilize the report below to find all AD Users and managers on your network.
Active Directory Users and Their Managers Query
Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email As Email,
tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain
From tblADusers
Left Join tblADObjects On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Order By tblADusers.Userdomain,
tblADusers.Username
