Reports

Active Directory Users and Their Managers

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. AD users and their managers

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

Show

Hide

Ready to get started?

Explore the full platform, free for 14 days.
No credit card required.

Need help evaluating?
Get guidance on pricing at scale and enterprise requirements.
Talk to sales
Clear pricing as you grow
Transparent plans that scale with your environment.
View plans & pricing