I am trying to query LDAP/AD to determine the users who have specific roles.
1. I have created a base view that queries users returning CN and DN.
2. I have created a base view that queries groups returning MemberOf and PrincipalName.
Each of these queries works individually.
- I would like to join these views on DN=MemberOf (this is valid, checked manually) but cannot because MemberOf is an array. 'MemberOf' contains 'MemberOf' as its member, I am not sure if this is contributing to the problem.
- When I attempt to flatten the groups view and join it to the users view, there is no data returned (even though there should be).
Has anyone done this this way or differently? Any suggestions?