‎08-16-2016 04:33 PM
Solved! Go to Solution.
‎08-16-2016 10:50 PM
Select tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname
From tblADusers
Where tblADusers.ADObjectID Not In (Select tblADMembership.ChildAdObjectID
From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
tblADMembership.ParentAdObjectID Where tblADGroups.Name = 'Domain Admins')
Order By tblADusers.Username
‎08-17-2016 02:52 PM
‎08-16-2016 10:50 PM
Select tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname
From tblADusers
Where tblADusers.ADObjectID Not In (Select tblADMembership.ChildAdObjectID
From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
tblADMembership.ParentAdObjectID Where tblADGroups.Name = 'Domain Admins')
Order By tblADusers.Username
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now