{"id":408,"date":"2017-09-08T15:54:32","date_gmt":"2017-09-08T13:54:32","guid":{"rendered":"https:\/\/msb365.abstergo.ch\/?p=408"},"modified":"2023-06-23T13:12:31","modified_gmt":"2023-06-23T11:12:31","slug":"export-distribution-group-members-one-csv-orand-delete-empty-distribution-groups","status":"publish","type":"post","link":"https:\/\/www.msb365.blog\/?p=408","title":{"rendered":"Export all Distribution Group and All members in one CSV or\/and delete empty Distribution Groups"},"content":{"rendered":"

In some situations we have to Export all the Distribution group and all the members of it to a CSV file. There is no command let available to retrieve the distribution group and distribution group members in bulk. Pipe line won\u2019t work in this case.<\/p>\n

DisplayName
\nAlias
\nRecipientType
\nRecipient OU
\nPrimary SMTP address
\nDistribution Group
\nDistribution Group Primary SMTP address
\nDistribution Group Managers
\nDistribution Group OU<\/p>\n

Satheshwaran Manoharan<\/a><\/strong>\u00a0wrote a script which will make Exchange Administrators life Easy to export distribution group and its members. After checking this Script I thought it would be cool, to be able, that I have a Option to delete all Distribution Groups witch has no Members in.<\/p>\n

That’s why I started first to modify his Script.<\/p>\n

First I added for the CSV export two more options (WhenCreated and\u00a0WhenChanged), this helps me, to get more Informations about all Distribution Groups.<\/p>\n

After running the Script .\\DistributionGroupMemberReport.ps1 you will get the Menue bellow:<\/span><\/span><\/p>\n

\"\"<\/p>\n

Output of CSV file look like Below<\/p>\n

You can add some more entries if required<\/p>\n

\"\"<\/p>\n

You can download the Script on my Github Page here!<\/a><\/strong><\/em><\/p><\/blockquote>\n

Please Note! The Initial Script was written by\u00a0Satheshwaran Manoharan<\/a><\/strong><\/p>\n

 <\/p>\n

How to use this Script for Office 365<\/strong><\/p>\n

Local desktop . PowerShell \u2013 Run as Administrator<\/p>\n

Make Sure your Execution Policy is set to RemoteSigned or Unrestricted<\/p>\n

\n
\n\n\n\n
\n
\n
Set-ExecutionPolicy<\/code> RemoteSigned<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

my Case its unrestricted.<\/p>\n

To Get Execution Policy Status<\/p>\n

\n
\n\n\n\n
\n
\n
Get-ExecutionPolicy<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n\n\n\n
\n
\n
$UserCredential<\/code> = <\/code>Get-Credential<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

$Session<\/code> = <\/code>New-PSSession<\/code> -ConfigurationName<\/code> Microsoft.Exchange<\/code> -ConnectionUri<\/code> https:\/\/outlook.office365.com\/powershell-liveid\/<\/a><\/code> -Credential<\/code> $UserCredential<\/code> -Authentication<\/code> Basic<\/code> -AllowRedirection<\/code><\/p>\n

\n
\n\n\n\n
\n
\n
Import-PSSession<\/code> $Session<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now Run the Script \u2013 It should work.<\/p>\n<\/div>\n<\/div>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Photo by\u00a0Dmitry Tsellobenok<\/a>\u00a0on\u00a0Unsplash<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In some situations we have to Export all the Distribution group and all the members of it to a CSV file. There is no command let available to retrieve the distribution group and distribution group members in bulk. Pipe line won\u2019t work in this case. DisplayName Alias RecipientType Recipient OU Primary SMTP address Distribution Group […]<\/p>\n","protected":false},"author":1,"featured_media":3557,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1923,2,3],"tags":[],"class_list":["post-408","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-365","category-exchange","category-powershell"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=408"}],"version-history":[{"count":4,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":5205,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions\/5205"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/media\/3557"}],"wp:attachment":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}