Solved

EXPORT MAIL ADDRESSES EXCHANGE 2010

Posted on 2015-02-13
2
175 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Guy Lidbetter earned 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Pop culture is prime bait for hackers seeking to infect user’s computers and mobile devices with malicious malware. Hackers know exactly what the latest trends are online and know how to use them to their advantage.
Article by: Dermot
The life of crime is over for 22 year-old Christian Ian Salvador, a student from Isabela State University in the Philippines.
The purpose of this video is to demonstrate how to set up a Mailchimp Template which will let the user create a uniform look for all of their campaigns. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mail…
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…

738 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