Find members of AD group
select Username, Firstname, Lastname, OU, WhenCreated, WhenChanged, a.lastChangedfrom tblADGroups ainner join tblADMembership b on a.ADObjectID=b.ParentAdObjectIDinner join tblADusers c on C.ADObjectID=b.ChildAdObjectIDwhere a.name='Your group'