Export AD group membership

Question

Export AD group membership

skip hofmann 1

The accepted answer at https://learn.microsoft.com/en-us/answers/questions/980667/export-ad-group.html is exactly what i need, however i need it to export to just 1 .csv file, and also export the nested groups. Any help is greatly appreciated

Rich Matheisen 47,901 Reputation points

2022-11-08T19:07:55.29+00:00

By "nested groups" do you mean you only want the users that are members of the nested groups, or do you want to know the group(s) in which the users were found?

I'm guessing that you want only the members of all groups and not the name of the groups in which they are members. If so, just change the code in the original question in the link you posted by adding "-Recursive" to the Get-ADGroupMember cmdlet.
skip hofmann 1 Reputation point

2022-11-08T20:10:47.453+00:00

Hello

I want to know the name of the groups that the users are found in, and i also need to know if the group contains a group as a member, and send everything to one .csv file. Example

Thanks again for you help

column1 column2
groupA groupC
user2 user4
user3 user5
groupB groupD

1 answer

Your answer

Rich Matheisen 47,901 Reputation points

2022-11-08T19:07:55.29+00:00

By "nested groups" do you mean you only want the users that are members of the nested groups, or do you want to know the group(s) in which the users were found?

I'm guessing that you want only the members of all groups and not the name of the groups in which they are members. If so, just change the code in the original question in the link you posted by adding "-Recursive" to the Get-ADGroupMember cmdlet.
skip hofmann 1 Reputation point

2022-11-08T20:10:47.453+00:00

Hello

I want to know the name of the groups that the users are found in, and i also need to know if the group contains a group as a member, and send everything to one .csv file. Example

Thanks again for you help

column1 column2
groupA groupC
user2 user4
user3 user5
groupB groupD

Answer 1

To get the group membership and the groups to which members belong might require the use of recursive code. It would also require you to take into account that groups may be members of multiple groups and those groups may be members of groups you've already processes -- so you'd have to keep track of what's already been processed and avoid processing it again to avoid an endless loop.

There are many examples that use PowerShell to give you a hierarchical list of group memberships. Start by searching for "powershell group membership recurse".

I'm not sure I understand your example of the CSV though. Are user2, user4, user3, and user5 members of groupC or groupA? Is groupB a member of groupA or groupC?

Share via

Export AD group membership

1 answer

Your answer