export mail contact mail user and external contacts

Question

export mail contact mail user and external contacts

Glenn Maxwell 12,876

Hi All,

I have distribution lists (DLs) created in both Exchange Online and Exchange On-Premises. These DLs include mail contacts, mail users, and external users. Some DLs are created in Exchange Online, while others are created in Exchange On-Premises.

I want to export all the DLs that contain mail contacts, mail users, or external users to a CSV file so that I can remove them from the DLs.

Could you please help me with a PowerShell script to fetch this information from both DLs and Unified Groups?

Accepted answer

0 additional answers

Your answer

Answer 1

Anonymous

Hi @Glenn Maxwell ,

Welcome to the Microsoft Q&A platform!

Below is a PowerShell script that you can use to fetch distribution lists (DLs) containing mail contacts, mail users, or external users from both Exchange Online and Exchange On-Premises, and export the information to a CSV file.

For Exchange Online:

Connect to Exchange Online:

$UserCredential = Get-Credential
Connect-ExchangeOnline -UserPrincipalName $UserCredential.UserName -Password $UserCredential.Password

Fetch DLs and export to CSV:

$DLs = Get-DistributionGroup -ResultSize Unlimited
$DLsWithExternalUsers = @()

foreach ($DL in $DLs) {
    $Members = Get-DistributionGroupMember -Identity $DL.Identity
    foreach ($Member in $Members) {
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName = $DL.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

$DLsWithExternalUsers | Export-Csv -Path "C:\DLsWithExternalUsers_ExchangeOnline.csv" -NoTypeInformation

For Exchange On-Premises:

Open Exchange Management Shell and run:

$DLs = Get-DistributionGroup -ResultSize Unlimited
$DLsWithExternalUsers = @()

foreach ($DL in $DLs) {
    $Members = Get-DistributionGroupMember -Identity $DL.Identity
    foreach ($Member in $Members) {
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName = $DL.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

$DLsWithExternalUsers | Export-Csv -Path "C:\DLsWithExternalUsers_ExchangeOnPremises.csv" -NoTypeInformation

For Unified Groups (Office 365 Groups):

Connect to Exchange Online:

$UserCredential = Get-Credential
Connect-ExchangeOnline -UserPrincipalName $UserCredential.UserName -Password $UserCredential.Password

Fetch Unified Groups and export to CSV:

$UnifiedGroups = Get-UnifiedGroup -ResultSize Unlimited
$UnifiedGroupsWithExternalUsers = @()

foreach ($Group in $UnifiedGroups) {
    $Members = Get-UnifiedGroupLinks -Identity $Group.Identity -LinkType Members
    foreach ($Member in $Members) {
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $UnifiedGroupsWithExternalUsers += [PSCustomObject]@{
                GroupName = $Group.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

$UnifiedGroupsWithExternalUsers | Export-Csv -Path "C:\UnifiedGroupsWithExternalUsers.csv" -NoTypeInformation

This script will help you identify and export the distribution lists and unified groups containing mail contacts, mail users, or external users to CSV files.

Please feel free to contact me for any updates. And if this helps, don't forget to mark it as an answer.

Best,

Jake Zhang

Glenn Maxwell 12,876

I want to import DLs from a CSV file and export the output. I have over 80,000 DLs and more than 60,000 Unified Groups. Please help me correct the syntax.

For Exchange Online DLs

DLAlias
******@contoso.com
******@contoso.com

# Import the CSV file containing distribution group names
$DL-List = Import-Csv -Path "C:\temp\dlinput.csv"
$DLsWithExternalUsers = @()

foreach ($DLs in $DL-List) {
    # Get the distribution group by name from the CSV
    $DL = Get-DistributionGroup -Identity $DLs.DLAlias

    # Get members of the distribution group
    $Members = Get-DistributionGroupMember -Identity $DL.Identity

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $DL.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$DLsWithExternalUsers | Export-Csv -Path "C:\temp\DLsWithExternalUsers_ExchangeOnline.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\temp\DLsWithExternalUsers_ExchangeOnline.csv"

For Unified Groups


UGAlias
******@contoso.com
******@contoso.com


# Import the CSV file containing unified group names
$UG-List = Import-Csv -Path "C:\temp\uginput.csv"
$UnifiedGroupsWithExternalUsers = @()

foreach ($UGs in $UG-List) {
    # Get the unified group by name from the CSV
    $Group = Get-UnifiedGroup -Identity $UGs.UGAlias

    # Get members of the unified group
    $Members = Get-UnifiedGroupLinks -Identity $Group.Identity -LinkType Members

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $UnifiedGroupsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $Group.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$UnifiedGroupsWithExternalUsers | Export-Csv -Path "C:\temp\UnifiedGroupsWithExternalUsers.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\temp\UnifiedGroupsWithExternalUsers.csv"

For OnpremDLs.


OnpremDLAlias
onprem******@contoso.com
onprem******@contoso.com


# Import the CSV file containing distribution group names
$OnpremDL-List= Import-Csv -Path "C:\temp\dlinput.csv"
$DLsWithExternalUsers = @()

foreach ($DLs in $OnpremDL-List) {
    # Get the distribution group by name from the CSV
    $DL = Get-DistributionGroup -Identity $DLs.OnpremDLAlias

    # Get members of the distribution group
    $Members = Get-DistributionGroupMember -Identity $DL.Identity

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $DL.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$DLsWithExternalUsers | Export-Csv -Path "C:\Temp\DLsWithExternalUsers_ExchangeOnPremises.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\Temp\DLsWithExternalUsers_ExchangeOnPremises.csv"

Anonymous

Hi @Glenn Maxwell ,

Thanks for your response!

Here are the updated scripts for each scenario:

For Exchange Online DLs:

# Import the CSV file containing distribution group names
$DLList = Import-Csv -Path "C:\temp\dlinput.csv"
$DLsWithExternalUsers = @()

foreach ($DL in $DLList) {
    # Get the distribution group by name from the CSV
    $DistributionGroup = Get-DistributionGroup -Identity $DL.DLAlias

    # Get members of the distribution group
    $Members = Get-DistributionGroupMember -Identity $DistributionGroup.Identity

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $DistributionGroup.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$DLsWithExternalUsers | Export-Csv -Path "C:\temp\DLsWithExternalUsers_ExchangeOnline.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\temp\DLsWithExternalUsers_ExchangeOnline.csv"

For Unified Groups:

# Import the CSV file containing unified group names
$UGList = Import-Csv -Path "C:\temp\uginput.csv"
$UnifiedGroupsWithExternalUsers = @()

foreach ($UG in $UGList) {
    # Get the unified group by name from the CSV
    $Group = Get-UnifiedGroup -Identity $UG.UGAlias

    # Get members of the unified group
    $Members = Get-UnifiedGroupLinks -Identity $Group.Identity -LinkType Members

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $UnifiedGroupsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $Group.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$UnifiedGroupsWithExternalUsers | Export-Csv -Path "C:\temp\UnifiedGroupsWithExternalUsers.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\temp\UnifiedGroupsWithExternalUsers.csv"

For On-Premises DLs:

# Import the CSV file containing distribution group names
$OnpremDLList = Import-Csv -Path "C:\temp\dlinput.csv"
$DLsWithExternalUsers = @()

foreach ($DL in $OnpremDLList) {
    # Get the distribution group by name from the CSV
    $DistributionGroup = Get-DistributionGroup -Identity $DL.OnpremDLAlias

    # Get members of the distribution group
    $Members = Get-DistributionGroupMember -Identity $DistributionGroup.Identity

    foreach ($Member in $Members) {
        # Check if the member is external
        if ($Member.RecipientType -eq 'MailContact' -or $Member.RecipientType -eq 'MailUser' -or $Member.ExternalEmailAddress) {
            $DLsWithExternalUsers += [PSCustomObject]@{
                GroupName  = $DistributionGroup.DisplayName
                MemberName = $Member.DisplayName
                MemberType = $Member.RecipientType
            }
        }
    }
}

# Export the results to a CSV file
$DLsWithExternalUsers | Export-Csv -Path "C:\Temp\DLsWithExternalUsers_ExchangeOnPremises.csv" -NoTypeInformation
Write-Host "Export completed. File saved to C:\Temp\DLsWithExternalUsers_ExchangeOnPremises.csv"

Please feel free to contact me for any updates. And if this helps, don't forget to mark it as an answer.

Best,

Jake Zhang

Anonymous

2025-01-17T09:38:22.0033333+00:00

Hi @Glenn Maxwell ,

Please kindly consider this comment as a warm follow up, I want to know if your problem has been solved. If you still have any other questions, please feel free to comment here and I'm glad to provide further support.If the above info is helpful to this question, you can click "Accept Answer". Have a nice day!

Best,

Jake Zhang

Share via

export mail contact mail user and external contacts

0 additional answers

Your answer