Get-DistributionGroup

Question

Hi All,

I have a list of Distribution Lists (DLs) in a CSV file in the following format:

DLList
dl1@contoso.com
dl2@contoso.com

I want to import this CSV file and retrieve the following information for each DL:

1. The count of DL members, including nested DLs.
2. The delivery management settings, specifically the sender options for the DL, such as:
   • "Only allow messages from people inside my organization" or
     • "Allow messages from people inside and outside my organization."
     1. If any DL has specified senders, I need a list of those users.

I also need to export this information to a CSV file. I am currently using the script below, which provides the DL member count (including nested DLs) for each DL. please guide me how to fetch this information.

# Define the distribution group
$groupName = "mydl@contoso.com"
# Get the distribution group object
$group = Get-DistributionGroup -Identity $groupName
 
# Get all members of the distribution group
$members = Get-DistributionGroupMember -Identity $group -ResultSize Unlimited
 
# Initialize a counter for total members
$totalMembers = 0
 
# Loop through each member
foreach ($member in $members) {
    # Increment the counter
    $totalMembers++
     # Check if the member is a group
    if ($member.ObjectClass -eq "Group") {
        # Recursively get members of the nested group
        $nestedMembers = Get-DistributionGroupMember -Identity $member.DistinguishedName -ResultSize Unlimited
        $totalMembers += $nestedMembers.Count
    }
}
 # Output the total member count
Write-Output "Total members including nested groups: $totalMembers" 

Answer 1

Hi,@Roger Roger

Thanks for posting your question in the Microsoft Q&A forum.

1. First, ensure you have the necessary permissions to perform these actions and that you're connected to your Exchange server or Office 365 via PowerShell.
2. Import the CSV file containing the Distribution Lists using the Import-Csv cmdlet:

$DLs = Import-Csv -Path "C:\Path\To\Your\File.csv"

3. Iterate over each Distribution List in the CSV and retrieve the necessary information. You can use the Get-DistributionGroup and Get-DistributionGroupMember cmdlets to get the details:

$DLInfo = foreach ($DL in $DLs) {
    $DLName = $DL.DLList
    $Members = Get-DistributionGroupMember -Identity $DLName -ResultSize Unlimited
    $DLSettings = Get-DistributionGroup -Identity $DLName
    
    $MemberCount = $Members.Count
    $DeliveryManagement = $DLSettings.ManagedBy
    $SenderRestrictions = $DLSettings.AcceptMessagesOnlyFrom
    
    [PSCustomObject]@{
        DLName = $DLName
        MemberCount = $MemberCount
        DeliveryManagement = if ($DLSettings.RequireSenderAuthenticationEnabled) {
            "Only allow messages from people inside my organization"
        } else {
            "Allow messages from people inside and outside my organization"
        }
        SpecifiedSenders = $SenderRestrictions -join ", "
    }
}

4. Finally, export the gathered information to a new CSV file using the Export-Csv cmdlet:

$DLInfo | Export-Csv -Path "C:\Path\To\Your\ExportedFile.csv" -NoTypeInformation

Here are my tests:

The result of exporting the file:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.