Solved

Exchange PowerShell:  Get all Primary SMTP Addresses of members of Distribution List

Posted on 2013-06-24
5
3,063 Views
Last Modified: 2013-06-24
I have following script to export primary smtp addresses of a particular distribution list:

$HelloMailboxes = "HelloMailboxes"
$PathExportMailboxes = "C:\upload\HelloMailboxes.csv"


Get-DistributionGroupMember $HelloMailboxes  | Select PrimarySmtpAddress | Export-Csv $PathExportMailboxes -NoTypeInformation

Open in new window


The output of the command is:
"PrimarySmtpAddress"
"mary@haylock.ch"
"marie@haylock.ch"
"leandro@haylock.ch"
"buchhaltung@haylock.ch"
"bibliothek@haylock.ch"

Open in new window


I would like to have following output (without header and " characters):
mary@haylock.ch
marie@haylock.ch
leandro@haylock.ch
buchhaltung@haylock.ch
bibliothek@haylock.ch

Open in new window

0
Comment
Question by:whenz
  • 2
  • 2
5 Comments
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 39273033
Try..
Get-DistributionGroupMember $HelloMailboxes  | %{Add-Content C:\Group.txt $_.PrimarySmtpAddress.ToString()}

Open in new window

0
 

Author Closing Comment

by:whenz
ID: 39273041
Perfect as always!
0
 
LVL 40

Expert Comment

by:Subsun
ID: 39273050
Another option..
Get-DistributionGroupMember $HelloMailboxes  | %{$_.PrimarySmtpAddress.ToString()} >C:\Group.txt 

Open in new window

0
 
LVL 4

Expert Comment

by:Dash Amr
ID: 39273058
This can be done from ADUC , where as you can create a query to get all the users and then from add and remove coloumn , you can add email address and then export the list to a csv file.

If you have the Saved query folder in teh Active Directory Users and computers Snap-in then you can do this:

1. Right-Click the folder and select New query
2. Give it a descriptive name
3. Click Define Query
4. From the drop down list select Custom Search
5. Clcik Advanced tab
6. Paste in the following:

(&(objectCategory=user)(memberOf=cn=Domain Admins,cn=users,dc=YourDomain,dc=local))

You will need to change the cn=..... part to suite your groups distinguished name.

then once you save this and get a list you can:
7. Right-click on your query
8. Select Export List (not Export Query definition as this just creates a backup of the query)
9. Select from the save as type:
   Text (Comma Delimited) (*.csv)
Which of course, opens in Excel as it is.

Cheers
Dash
0
 
LVL 4

Expert Comment

by:Dash Amr
ID: 39273085
Herein Attached a Script for o make it easier for you.

What does the script exactly do?

    1- Queries Active Directory for Contacts & Groups
    2- Lists their email addresses
    3- Queries Users
    4- Lists enabled users’ email addresses
    5- Lists disabled users’ email addresses separately (was required for a certain project I did a long time back)
    6- Outputs to command line and also to a text file – c:\proxyaddresses.txt
    - X.400 addresses are ignored
ListEmailAddresses.zip
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Powershell script to find Office version of all PC's in an OU 1 23
Exchange 2016 OWA attachment issues 4 41
Powershell Split 18 27
Ruby or Python 7 42
A brief introduction to what I consider to be the best editor for PowerShell.
In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question