How to get user name and respective group membership in active directory with powershell

user_19258418 0
Viewed 53

I want to get the list of users and respective group membership by powershell.

like:

Name    GroupName
user1     group1
user1     group2
user2     group3

I creted a script like this

get-aduser -filter * -properties memberof | %{select $._Name, @{Name='GroupName' ; Expression={get-adprincipalgroupmembership $._distinguisedName | Select Name }}}

but not getting any output.

Any help will be appriciated.

powershell active-directory
1 Answers

The syntax used for your calculated property on Select-Object is incorrect as Daniel pointed out in his helpful comment, in addition, foreach loop is also better in this case:

foreach($user in Get-ADUser -Filter * -Properties MemberOf) {
    Get-ADPrincipalGroupMembership $user |
        Select-Object @{N='User'; E={ $user.Name }}, @{N='GroupName'; E='Name'}
}
user_153395440
Related