Get-DistributionGroup

Question

Get-DistributionGroup

Roger Roger 7,181

Hi All,

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

DLList
******@contoso.com
******@contoso.com

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

The count of DL members, including nested DLs.
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 = "******@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"

Anonymous

2024-11-07T05:09:53.57+00:00

Hello, @Roger Roger

It's been a long time since I've heard from you, have you solved your problem yet? Did my previous reply help you？ If it was useful, you can mark it as an answer. Thank you for your understanding and support.
Anonymous

2024-11-18T06:57:51.4033333+00:00

Hi, @ Roger Roger

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Anonymous

2024-11-07T05:09:53.57+00:00

Hello, @Roger Roger

It's been a long time since I've heard from you, have you solved your problem yet? Did my previous reply help you？ If it was useful, you can mark it as an answer. Thank you for your understanding and support.
Anonymous

2024-11-18T06:57:51.4033333+00:00

Hi, @ Roger Roger

Just checking in to see if the below answer helped. If this answers your query, please don’t forget to click "Accept Answer" which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Hi,@Roger Roger

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

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.
Import the CSV file containing the Distribution Lists using the Import-Csv cmdlet:

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

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 ", "
    }
}

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:

User's image

The result of exporting the file:

User's image

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.

Anonymous

2024-11-25T06:06:14.59+00:00

Hello, @Roger Roger

It's been a long time since I've heard from you, have you solved your problem yet? Did my previous reply help you？ If it was useful, you can mark it as an answer. Thank you for your understanding and support.

Share via

Get-DistributionGroup

0 additional answers

Your answer