Get-DistributionGroupMember

Question

Hi All,

I am using an Exchange 2016 hybrid environment. We create users on-premises and then migrate them online. I have distribution lists both in Exchange on-premises and online. I want to export the user list from an on-premises distribution list. I am using the syntax below, but I am not getting output for all the attributes:

Get-DistributionGroupMember -Resultsize Unlimited onpremDL1@contoso.com| Select DisplayName,title,userprincipalname,PrimarySMTPAddress,RecipientType,Department,Manager |  Export-csv -path C:\temp\DLoutput.csv -NoTypeInformation 

Is it possible to export onprem DLs user list from online. My requirement either it be onprem or online DL, i want to export DL members with the below information. I have this information both in onprem and online but i am unable to export.(the below attributes are synced to AzureAD as well). please guide me.

(DisplayName,JobTitle,userprincipalname,PrimarySMTPAddress,RecipientType,Department,Manager,EmployeeID,Office,Country,EmployeeType).

Answer 1

Hi，@Rising Flight

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

According to your description, you want the newsletter group list to export the user list and get the output of all the attributes.

You don't get all the parameters of a member when you use Get-Distribution. Some parameters require the Get-maibox and Get-User commands to get them.

 

Here is my solution:

1. Enter the following command in Exchange Online PowerShell:

Get-DistributionGroupMember -Identity "YourDLName" | Get-Mailbox | Select-Object DisplayName, UserPrincipalName, PrimarySmtpAddress, RecipientType, @{Name='Title';Expression={(Get-User $_.UserPrincipalName).Title}}, @{Name='Department';Expression={(Get-User $_.UserPrincipalName).Department}}, @{Name='Manager';Expression={(Get-User $_.UserPrincipalName).Manager}}, @{Name='EmployeeID';Expression={(Get-User $_.UserPrincipalName).EmployeeID}}, @{Name='Office';Expression={(Get-User $_.UserPrincipalName).Office}}, @{Name='CountryOrRegion';Expression={(Get-User $_.UserPrincipalName).CountryOrRegion}}, @{Name='EmployeeType';Expression={(Get-User $_.UserPrincipalName).EmployeeType}}
| Export-Csv -Path "C:\DLmembers.csv" -NoTypeInformation

2. There were no errors, then go to the C drive and find the exported file.

3. Open the file.

If my answer is helpful to you, please mark it as the answer so that other users can refer to it. Thank you for your support and understanding.