question

ChandruR-3065 avatar image
0 Votes"
ChandruR-3065 asked ChandruR-3065 answered

Export DL Properties in Exchange Online

Hi,
I have a requirement to export properties of 2000+ DL.
I can import DL and | fl to take all properties but I would like to export the properties in the csv format or excel.
Is there any script we can use to export DL all properties in Exchange online?

Thanks
CT 7

office-exchange-online-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ChandruR-3065

Any update about this thread now? Do you export data successfully?

0 Votes 0 ·
michev avatar image
0 Votes"
michev answered

That's why we have the Export-CSV cmdlet. Here's an example:

 Get-DistributionGroup -ResultSize Unlimited | Select * | Export-Csv -nti DGs.csv
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ChandruR-3065 avatar image
0 Votes"
ChandruR-3065 answered

Hi michev, thanks for your reply. this command only exports limited properties of DL
I would like to export all properties of DL into excel.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KyleXu-MSFT avatar image
0 Votes"
KyleXu-MSFT answered

@ChandruR-3065

Which attributes do you want to export that are not included in the Get-DistributionGroup command?

I can import DL and | fl to take all properties

What is the command that you used? If you could check all properties from that command, you will could use "| Export-Csv c:/name.csv" to export them to a CSV file.


If the response is helpful, please click "Accept Answer" and upvote it.
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ChandruR-3065 avatar image
0 Votes"
ChandruR-3065 answered

My apologies. this command helped me to export all properties of Distribution Groups. I did not see select * in the command initially.

Get-DistributionGroup -ResultSize Unlimited | Select * | Export-Csv -nti DGs.csv

Thank you michev..

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.