PowerShell ADGroup details

Question

How can I output the ADGroup name and the email address members of ADGroups with name of group starting with 'MY-GROUP*' I manage to export all the desired groups but I'm struggling to get only the email.

> $adgroups = Get-ADGroup -Filter {Name -like 'MY-GROUP*'} | sort
> name
> 
> $data = foreach ($adgroup in $adgroups) {
>     $members = $adgroup | get-adgroupmember | sort name
>     foreach ($member in $members) {
>         [PSCustomObject]@{
>             Group   = $adgroup.name
>             Members = $member
>         }
>     } } $data | select Group, Members

The desired output would something like this :

| GroupName    | mail            |
| ---------    | --------------- |
| MY-GROUP-1   | [email protected]|
| MY-GROUP-1   | [email protected]|
| MY-GROUP-1   | [email protected]|
| MY-GROUP-2   | [email protected]|
| MY-GROUP-2   | [email protected]|
| MY-GROUP-2   | [email protected]|
| MY-GROUP-3   | [email protected]|
| MY-GROUP-3   | [email protected]|

You will need to start by retrieving a list of groups, and then retrieving the members of each group. I commend your attention to the output of Get-ADGroup and the output of Get-Help about_ActiveDirectory_Filter. — Jeff Zeitlin

dmartins dmartins · Accepted Answer · 2021-01-05T12:10:48

This did the trick for me :

$adgroups = Get-ADGroup -Filter {Name -like 'MY-GROUP-*'} | sort name

$data = foreach ($adgroup in $adgroups) {
    $members = $adgroup | get-adgroupmember | get-aduser -Properties mail | select mail
    foreach ($member in $members) {
        [PSCustomObject]@{
            Group   = $adgroup.name
            Members = $member
        }
    }
}
$data | select Group, Members

PowerShell ADGroup details

1 Answers