PowerShell export only Primary addresses

[Davit2005]

I am trying to export a CSV from Office365 of just primary email address ( i.e. the one that should be the reply adddress )

 

I have PowerShell command that exports email addresses but this does not tell me the primary address i.e. the first email address is not necessarily the primary address as I found checking one user.

 

Anyone know a specific switch to give me just the primary email address.

 

Thanks

[ascott2]

I'm not entirely sure that O365 is the same as on premise exchange but in Exchange it's just Get-Mailbox | Select PrimarySMTPAddress Edited July 24, 2014 by ascott2
Typo

[EduTech]

I am trying to export a CSV from Office365 of just primary email address ( i.e. the one that should be the reply adddress )

 

I have PowerShell command that exports email addresses but this does not tell me the primary address i.e. the first email address is not necessarily the primary address as I found checking one user.

 

Anyone know a specific switch to give me just the primary email address.

 

Thanks

 

Hi,

 

If you want to do this using the Exchange Module, Then you can use the following command:

 

Get-Mailbox | fl DisplayName, PrimarySMTPAddress

 

or if you want grid view

 

Get-Mailbox | Select DisplayName, PrimarySMTPAddress | Out-GridView

 

or, if you want to use the MSOL Commands:

 

Get-MSOLUser | Select -Expand Proxyaddresses | ? {$_ -cmatch '^SMTP\:.*'}

 

I hope that helps,

James.

[Davit2005]

Thankyou both,

 

The script I used for anyone else benefit is

 

Get-Mailbox -ResultSize Unlimited | Select PrimarySMTPAddress | Export-Csv FILEPATH.csv -NoTypeInformation