Search code examples
powershellexchange-server

Exporting Mailbox Attributes from Exchange 2010 to CSV using Exchange Management Shell

I'm currently looking at dumping some user contact details out of the exchange to import into another system which holds contact details (.csv).

The requirements are found when manually doing an export inside EMC 2010. However, I can't seem to get the PowerShell attribute names right.

The fields are Company, Primary SMTP Address, First Name, Last Name, Title, Department, Phone, Recipient Type Details, Hidden from Address Lists

I can only seem to find the DisplayName and Primary email address

Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,PrimarySmtpAddress,  @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where{$_.HiddenFromAddressListsEnabled -eq $true} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV C:\temp\smtp.csv -NoTypeInformation

Is there a way to get a list of what all the Get-Mailbox attributes are?

Solution

  • Run this:

    Get-Mailbox <your primary smtp address> | format-list *

    and see if that doesn't provide some clues.