Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

EXPORT MAIL ADDRESSES EXCHANGE 2010

Posted on 2015-02-13
2
Medium Priority
?
206 Views
Last Modified: 2015-02-13
Hello - I need to export all of mail addressed inclusive of alias addresses into a single column CSV file for import into a cloud based Spam filter.

I found this on line

Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\smtp.csv -NoTypeInformation

It is helpful but I need the alias addresses to appear in the 1st column as separate addresses.  Can anyone help I have no idea how to achieve this

Byron
0
Comment
Question by:BYRONJACKSON
2 Comments
 
LVL 13

Accepted Solution

by:
Guy Lidbetter earned 2000 total points
ID: 40607882
Hi Byron..

Give this a go...

$MailAccounts =  Get-Mailbox -Resultsize Unlimited | Select -ExpandProperty EmailAddresses
$MailAccounts.SMTPAddress | Export-CSV <FileName>

Regards

Guy

EDIT: It only provides a list of all mailbox users email addresses (Primary and Proxy) - nothing else. You would need to do the same for Distribution groups and mail enabled Public folders.
0
 

Author Closing Comment

by:BYRONJACKSON
ID: 40608273
Thank you! Perfect
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

Question has a verified solution.

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

Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

577 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