Exporting Distribution List Details

Let’s assume that you have a large organization with a ‘N’ number of Distribution Groups. You or one of your manager wants to know who is managing which Distribution Groups, who can able to send mails to the DL’s, who are the members of the DL and other details.

You can do this with several many ways. But I will show you how you can achieve this in few simple Cmdlets easily in my way.

Note: Instead of simply giving you the Cmdlet to export or list out the details, I am showing you how you can figure out yourself to resolve similar issue or export the lists. If you already familiar with the PowerShell, please scroll down to the end of the page to see the final Cmdlet to export the list.

Now, let’s get all the Distribution lists in a Variable called Distribution Groups.

 $DistributionGroups = Get-DistributionGroup -ResultSize Unlimited

You can see all the information stored in the variable by entering $DistributionGroups.

If you just want to know how many DL’s you have in the memory/stored in the variable, you can do

 $DistributionGroups.Count

Now, Lets Export the details which we want. Here, I am Exporting the Group Name, Group Email Address, who manages the Group / Group Manager, who can send mails to the Security restricted groups, Group Members, Group Member samAccountName.

 $DG = foreach ($group in (Get-DistributionGroup -Filter {name -like "*"})) {Get-DistributionGroupMember $group | Ft @{Label="Group";Expression={$Group.Name}},@{Label="Group Mail Address";Expression={$Group.PrimarySMTPAddress}},@{Label="Group Owner";Expression={$Group.ManagedBy}},@{Label="Allowed Senders";Expression={$Group.AcceptMessagesOnlyFrom}},@{Label="Member";Expression={$_.Name}},SamAccountName}

Now, Let’s Export the output to a CSV file.

 $DG | Export-Csv “./DistributionGroupDetails.Csv”

The Above Cmdlet will save the .Csv file in the current directory from where you are running the PowerShell. As shown in the screenshot above, my current path on PowerShell is “C:\Windows\System32”. Hence the File will be created inside the “C:\Windows\System32\” folder