Report - AD Users in both groups

[sam1]

Hello,

i am trying to create a report which lists all users who are in both groups.

Im not an sql expert, maybe someone of you has an idea how i could create the report? 🙂

Here is what i have tried:

Select Top 1000000 tblADusers.Userdomain,
  tblADusers.Username,
  tblADusers.Name,
  tblADusers.OU,
  tblADusers.Lastchanged,
  tblADusers.whenCreated,
  tblADusers.IsEnabled,
  tblADusers.LockoutDate,
  tblADusers.PasswordLastSet,
  tblADusers.PasswordRequired
From tblADusers
Where (tblADusers.IsEnabled = 'True' And tblADusers.ADObjectID In (Select
        tblADMembership.ChildAdObjectID
      From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
            tblADMembership.ParentAdObjectID
      Where tblADGroups.Name = 'G_1')) Or
  (tblADusers.ADObjectID In (Select tblADMembership.ChildAdObjectID
      From tblADMembership Inner Join tblADGroups On tblADGroups.ADObjectID =
            tblADMembership.ParentAdObjectID
      Where tblADGroups.Name = 'G_2'))

[Mister_Nobody · Accepted solution]

Try replace or to and

[sam1]

Thank you! I guess i didn't pay attention.