Query Distribution list

Question

Hi All

I have dynamic Distribution lists in exchange online. I want to export those DDLs list to csv file. i.e Group Name, Group Email address and if possible Members i.e Recipient filter Query.(I dont wants members list, only the query used). Please guide me with the syntax. I am trying something like the below but i am not getting correct output.

(get-dynamicdistributiongroup).RecipientFilter -OrganizationalUnit $group.RecipientContainer | Select Displayname,alias,PrimarySmtpAddress | Export-Csv "c:\temp\list.csv" -Notypeinformation

Answer 1

Hi @Glenn Maxwell ,

You can connect to Exchange Online powershell and run the command below, I have tried in my environment it can work properly:

Get-DynamicDistributionGroup | Select DisplayName, Alias,PrimarySmtpAddress,RecipientFilter | Export-Csv "C:\temp\list.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.