‎12-31-2019 03:42 PM
‎12-31-2019 04:14 PM
Select tblADusers.Firstname As nameFirst,
tblADusers.Lastname As nameLast,
tblADusers.email As emailBusiness,
tblADusers.Lastname + ', ' + tblADusers.Firstname As userAccount,
tblADusers.Title,
tblADusers.Department
From tblADusers
Left Join tblADObjects On
tblADObjects.ADObjectID = tblADusers.ManagerADObjectId
Where tblADusers.Lastname Is Not Null And tblADusers.email Is Not Null
And tblADusers.HomeDirectory Is Not Null
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now