如何将所有电子邮件分发中所有用户的Active Directory列表保存到.CSV？

事实证明，这比我预期的要难得多-由于成员计数（您必须进行与整数相当的计数）。我添加了一种可能性，可以限制结果大小，因为对于大型查询，活动目录会产生超时。

$limit_result_size = 10

$group_name = Get-ADGroup -Filter {GroupCategory -eq "Distribution"} -Properties Name, Members -ResultSetSize:$limit_result_size | Select-object name

ForEach ($name in $group_name.name) {
    If ((![String]::IsNullOrEmpty("$name")) -And ("$name" -notlike 'index')) {
        $count_members = Get-ADGroupMember -Identity "$name" | Measure-Object | Select-Object Count
        Write-Output "The AD group $name has $($count_members.Count) members.`n"
        For($counter = 0; $counter -lt $count_members.Count; $counter++) {
            $person = Get-ADGroup -Filter {Name -eq $name} -Properties Name, Members | Select-Object Name, @{N='Members';E={$_.Members[$counter]}}
            $person.Members = $person.Members | Select-String 'CN=[0-9a-zA-Z]+' -AllMatches | % { $_.Matches } | % { $_.Value }
            $person | export-csv -NoTypeInformation -Append -Path '<your_path>\log.csv'
        }
    }
}

简短的介绍：

(![String]::IsNullOrEmpty("$name")) -And ("$name" -notlike 'index')) 广告组应满足的条件。

Select-String 'CN=[0-9a-zA-Z]+' -AllMatches | % { $_.Matches } | % { $_.Value }仅选择CN=string_with_numbers。CN=\w+如果愿意，可以将其替换为。

该脚本在CVAD group和中生成一对CN=user_name。如果还有其他不清楚的地方，请询问。

编辑

如果通用名称（CN）的名称中有空格，则必须将regexp调整为CN=[0-9a-zA-Z\s]+。

编辑2添加用户的电子邮件地址。

由于您的问题已包含在电子邮件的标题请求中，因此我将在此处回答而不会出现新问题。请注意，此解决方案在regexp中使用了lookbehind来CN=从输出中排除，因此可以将其用作用户查询的源。它还使用PSCustomObject将所有信息收集在一起的。我重命名了一些变量，以便在用户详细信息的上下文中更好地理解。

$limit_result_size = 10

$group_name = Get-ADGroup -Filter {GroupCategory -eq "Distribution"} -Properties Name, Members -ResultSetSize:$limit_result_size | Select-object name

ForEach ($name in $group_name.name) {
    If ((![String]::IsNullOrEmpty("$name")) -And ("$name" -notlike 'index')) {
        $count_members = Get-ADGroupMember -Identity "$name" | Measure-Object | Select-Object Count
        Write-Output "The AD group $name has $($count_members.Count) members.`n"
        For($counter = 0; $counter -lt $count_members.Count; $counter++) {
            $person = Get-ADGroup -Filter {Name -eq $name} -Properties Name, Members | Select-Object Name, @{N='Members';E={$_.Members[$counter]}}
            $person.Members = $person.Members | Select-String '(?<=CN=)[0-9a-zA-Z\s]+' -AllMatches | % { $_.Matches } | % { $_.Value }
            $person_details = Get-AdUser -filter {name -eq $member} -Properties mail | Select-Object mail
            $person_additional_details = [PSCustomObject]@{ group_name = $group.Name
                                                            user_name  = $group.Members
                                                            email      = $person_details.mail
                                                      }
            If ([String]::IsNullOrEmpty($($person_additional_details.email))) {
                $person_additional_details.psobject.properties["email"].value = '<empty>'
            }

        # For user to see the written data
        Write-Output "AD Group: $($person_additional_details.group_name) `
AD User: $($person_additional_details.user_name) `
Users`'s email: $($person_additional_details.email)`n"

        # writing into the CSV file
        $person_additional_details | export-csv -NoTypeInformation -Append -Path '<your_path>\log.csv'
        }
    }
}