Get-DistributionGroupMember

Question

Hi All

i have mail enabled security group in exchange online. i want to export the mail enabled security group members to csv file. will the below syntax work.

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

Answer 1

Hi @Roger Roger ,

UserPrincipalName will be empty in the command you shared above. Based on my test, you can use the command below so that all properties listed can be included:

Get-DistributionGroupMember -Resultsize Unlimited mailenabledsecuritygroup@contoso.com | %{Get-Mailbox $_.Name | select DisplayName,userprincipalname,@{Expression={(Get-User $_.Name).title};Label="title";},PrimarySMTPAddress,RecipientType} |  Export-csv -path C:\temp\output.csv -NoTypeInformation

---

---

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.

Answer 2

it will work, however not all selected properties will be exposed, as the output of the cmdlet returns a ReducedRecipient object. For example, Title and UserPrincipalName will be empty. If you need to include these properties, you will have to make additional calls to the Get-User cmdlet or similar.