Wednesday 27 January 2016

Export all your Exchange Email Addresses to CSV

This below command works with Exchange 2007 and 2010.

Open up exchange powershell and type this:

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

This will extract the users into a nice excel sheet in the C Drive for you to use.


To export the usernames and inbox sizes use the command below:

Get-mailbox | get-mailboxstatistics | sort-object totalitemsize –descending | ft displayname,totalitemsize | Export-CSV c:\emails.csv -NoTypeInformation

No comments:

Post a Comment