PowerShell ADGroup详细信息

Question

如何输出组名以"MY-group*"开头的ADGroups的ADGroup名称和电子邮件地址成员我设法导出了所有想要的组，但我很难只得到电子邮件。

> $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

想要的输出是这样的：

| GroupName    | mail            |
| ---------    | --------------- |
| MY-GROUP-1   | [e-mail]|
| MY-GROUP-1   | [e-mail]|
| MY-GROUP-1   | [e-mail]|
| MY-GROUP-2   | [e-mail]|
| MY-GROUP-2   | [e-mail]|
| MY-GROUP-2   | [e-mail]|
| MY-GROUP-3   | [e-mail]|
| MY-GROUP-3   | [e-mail]|

Answer 1

这对我来说很有用：

$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