‎12-20-2019 04:58 PM
‎12-30-2019 03:27 PM
‎12-24-2019 11:50 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now