Skip to main content

How to list all members of a Distribution group and their emails with PowerShell

This question came from the need of a user who needed to extract the following information:

Distribution Group Name | Group Email | Group Member | Member’s Email

 

Function Get-DistributionEmail

{

 

    # Get a list of all the distribution groups in the domain.

    $Groups = Get-ADGroup -Filter 'GroupCategory -eq "Distribution"' -Properties Mail

 

    # Create a dynamic array to hold the objects for the output.

    $Obj = @()

   

    # Loop through each group.

    ForEach ($Group in $Groups)

    {

        # Enumerate all the members of the group.

        $Members = Get-ADGroupMember -Identity $Group.name

       

        # Collect the data for the output.

        ForEach ($Member in $Members)

        {

            $GroupObj = New-Object PSObject

            $GroupObj | Add-Member `

             -MemberType NoteProperty `

             -Name "Group" `

             -Value $Group.Name

           

            $GroupObj | Add-Member `

             -MemberType NoteProperty `

             -Name "GroupEmail" `

             -Value $Group.Mail

 

            $GroupObj | Add-Member `

             -MemberType NoteProperty `

             -Name "User" `

             -Value $Member.Name

           

            $User = get-ADuser -filter 'Name -eq $Member.name' -Properties Mail

 

            $GroupObj | Add-Member `

             -MemberType NoteProperty `

             -Name "UserEmail" `

             -Value $User.Mail

 

             # Transfer the object to the dynamic array.

             $Obj += $GroupObj

        }

    }

    # Wrtie the contents of the array to the PowerShell pipeline.

    Write-Output $Obj | FT -AutoSize

<#

.SYNOPSIS

Gather all user accounts and email addresses of Distribution Group members.

 

.DESCRIPTION

Gather all user accounts and email addresses of Distribution Group members.

 

.EXAMPLE

Get-DistributionEmail

 

Group  GroupEmail      User  UserEmail    

-----  ----------      ----  ---------    

Group1 Group1@Indy.com User1 User1@Indy.com

Group1 Group1@Indy.com User2 User2@Indy.com

Group2 Group2@indy.com User3 User3@indy.com

Group2 Group2@indy.com User4 User4@indy.com

 

.NOTES

Requires the Active Directory module to be available.

#>

}

Comments

Biller said…
Cool ! I like it.

Popular posts from this blog

Adding a Comment to a GPO with PowerShell

As I'm writing this article, I'm also writing a customization for a PowerShell course I'm teaching next week in Phoenix.  This customization deals with Group Policy and PowerShell.  For those of you who attend my classes may already know this, but I sit their and try to ask the questions to myself that others may ask as I present the material.  I finished up my customization a few hours ago and then I realized that I did not add in how to put a comment on a GPO.  This is a feature that many Group Policy Administrators may not be aware of. This past summer I attended a presentation at TechEd on Group Policy.  One organization in the crowd had over 5,000 Group Policies.  In an environment like that, the comment section can be priceless.  I always like to write in the comment section why I created the policy so I know its purpose next week after I've completed 50 other tasks and can't remember what I did 5 minutes ago. In the Group Policy module for PowerShell V3, th

Return duplicate values from a collection with PowerShell

If you have a collection of objects and you want to remove any duplicate items, it is fairly simple. # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   # Remove the duplicate values. $Set1 | Select-Object -Unique 1 2 3 4 5 6 7 What if you want only the duplicate values and nothing else? # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   #Create a second collection with duplicate values removed. $Set2 = $Set1 | Select-Object -Unique   # Return only the duplicate values. ( Compare-Object -ReferenceObject $Set2 -DifferenceObject $Set1 ) . InputObject | Select-Object – Unique 1 2 This works with objects as well as numbers.  The first command creates a collection with 2 duplicates of both 1 and 2.   The second command creates another collection with the duplicates filtered out.  The Compare-Object cmdlet will first find items that are diffe

How to list all the AD LDS instances on a server

AD LDS allows you to provide directory services to applications that are free of the confines of Active Directory.  To list all the AD LDS instances on a server, follow this procedure: Log into the server in question Open a command prompt. Type dsdbutil and press Enter Type List Instances and press Enter . You will receive a list of the instance name, both the LDAP and SSL port numbers, the location of the database, and its status.