Friday, April 22, 2016

Exchange Mailbox and ProxyAddress Export Script

Get-Mailbox -Server EXSERVERNAME | select DisplayName, Alias, @{n="First Name";e={(get-user $_.name).FirstName }}, @{n="Last Name";e={(get-user $_.name).LastName }}, @{n="Country";e={(get-user $_.name).CountryOrRegion }}, @{n="Office";e={(get-user $_.name).Office }}, @{n="City";e={(get-user $_.name).City }}, @{n="Phone";e={(get-user $_.name).Phone }}, @{n="Mobile";e={(get-user $_.name).MobilePhone }}, OrganizationalUnit, RecipientTypeDetails, primarysmtpaddress, ForwardingAddress, DeliverToMailboxAndForward, @{n="Mailbox Size";e={(Get-MailboxStatistics $_.name).TotalItemSize.value.ToMB() }}, @{n="Title";e={(get-user $_.name).title }}, @{n="Department";e={(get-user $_.name).department }}, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}}, MaxsendSize, recipientlimits, database | Export-CSV c:\temp\Mailboxes.csv