Get-DistributionGroup-UnifiedGroup

Question

Hi All,

I am using an Exchange hybrid environment. I have over 50,000 distribution lists, 40,000 unified groups, and 7,000 mail-enabled security groups.

I want to export their Names, Display Names, Primary SMTP addresses, Aliases, and Descriptions to a CSV file. My requirement is to export:

• All distribution lists and mail-enabled security groups from both Exchange Online and Exchange on-premises.
• Unified groups in Exchange Online.

For Exchange Online distribution lists, I would also like to export the sync status to determine whether the list is an on-premises or online distribution list. Please guide me with the PowerShell syntax.

Answer 1

Hello, @Roger Roger,

Welcome to the Microsoft Q&A platform!

Based on your requirements, exporting such data from both on-premises Exchange and Exchange Online involves using the Exchange Management Shell (EMS) for on-premises Exchange and the Exchange Online PowerShell module for Exchange Online.

Below are the steps and scripts to help you export the required information:

1. Export Distribution Lists and Mail-Enabled Security Groups from Exchange On-Premises by using Exchange Management Shell

Get-DistributionGroup -ResultSize Unlimited | Select-Object Name, DisplayName, PrimarySmtpAddress, Alias, Description | Export-Csv -Path "C:\temp\OnPrem_DistributionGroups.csv" -NoTypeInformation
>> Get-DistributionGroup -ResultSize Unlimited -RecipientTypeDetails MailUniversalSecurityGroup | Select-Object Name, DisplayName, PrimarySmtpAddress, Alias, Description | Export-Csv -Path "C:\temp\OnPrem_MailEnabledSecurityGroups.csv" -NoTypeInformation

2. Export Distribution Lists, Mail-Enabled Security Groups, and Unified Groups from Exchange Online by using Windows PowerShell

Connect-ExchangeOnline

Get-DistributionGroup -ResultSize Unlimited | Select-Object Name, DisplayName, PrimarySmtpAddress, Alias, Description, @{Name="SyncStatus";Expression={if ($_.IsDirSynced) {"Synced"} else {"Cloud"}}} | Export-Csv -Path "C:\temp\Online_DistributionGroups.csv" -NoTypeInformation
>> Get-DistributionGroup -ResultSize Unlimited -RecipientTypeDetails MailUniversalSecurityGroup | Select-Object Name, DisplayName, PrimarySmtpAddress, Alias, Description | Export-Csv -Path "C:\temp\Online_MailEnabledSecurityGroups.csv" -NoTypeInformation

Get-UnifiedGroup -ResultSize Unlimited | Select-Object Name, DisplayName, PrimarySmtpAddress, Alias, Description | Export-Csv -Path "C:\temp\Online_UnifiedGroups.csv" -NoTypeInformation

Disconnect-ExchangeOnline -Confirm:$false

3. Combine the CSV Files by using Windows PowerShell

$OnPremDGs = Import-Csv -Path "C:\temp\OnPrem_DistributionGroups.csv"
$OnPremMESGs = Import-Csv -Path "C:\temp\OnPrem_MailEnabledSecurityGroups.csv"
$OnlineDGs = Import-Csv -Path "C:\temp\Online_DistributionGroups.csv"
$OnlineMESGs = Import-Csv -Path "C:\temp\Online_MailEnabledSecurityGroups.csv"
$OnlineUGs = Import-Csv -Path "C:\temp\Online_UnifiedGroups.csv"

$AllGroups = $OnPremDGs + $OnPremMESGs + $OnlineDGs + $OnlineMESGs + $OnlineUGs
$AllGroups | Export-Csv -Path "C:\temp\All_Groups.csv" -NoTypeInformation

Command test results：

This will give you a single CSV file containing all the required information from both Exchange Online and Exchange on-premises.

Should you need more help on this, you can feel free to post back. 

---

If the answer is helpful, please click on “Accept answer” as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions.

Thank you for your support and understanding.

Best Wishes,

Alex Zhang