→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎08-11-2015 03:13 PM
Solved! Go to Solution.
‎08-13-2015 02:19 PM
Select Top 1000000 tblADusers.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Displayname
From tblADusers
Where tblADusers.Username Not Like 'admin %' And tblADusers.ADObjectID Not In
(Select tblADMembership.ChildAdObjectID
From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
tblADMembership.ParentAdObjectID
Where tblADGroups.Name Like 'group1 %')
Order By tblADusers.Username
‎08-13-2015 02:19 PM
Select Top 1000000 tblADusers.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Displayname
From tblADusers
Where tblADusers.Username Not Like 'admin %' And tblADusers.ADObjectID Not In
(Select tblADMembership.ChildAdObjectID
From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
tblADMembership.ParentAdObjectID
Where tblADGroups.Name Like 'group1 %')
Order By tblADusers.Username
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now