Active Directory: Users Missing from Group request

[dmeagle01]

Can I request a report be created?

Id like to have a report that will tell me what users are not in a specific group. By group I mean like jdoe is missing from the AD group Domain Administrators.

[dmeagle01]

Beautiful, appreciate it!

[MikeMc · Accepted solution]

This query should get you started. It will list all AD users not in the Domain Admins group.

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