Query list of email aliases in Exchange 2007

Question

What ways can i query my Exchange 2007 server for all email aliases used?

Answer 1

This should get you a list

Get-Mailbox | fl UserPrincipalName, Emailaddresses, PrimarySMTPaddress

This command will show you the user, smtp addresses and the primary address.

Answer 2

Sorry i didn't answer sooner, I ended up working a bit on my Google-fu and came up with the following which gave me the entire list of email addresses, primary or aliases for my entire domain. Thanks!

http://exchangepedia.com/2005/09/how-to-export-all-email-addresses-from-a-domain.html

Answer 3

Here it is mate:

Get-Mailbox -resultSize unlimited | foreach{
 $emails= $_ | select -expand EmailAddresses | where {$_.PrefixString -eq 'smtp'} | sort IsPrimaryAddress -desc | foreach {$_.smtpAddress}
 [string]::join(",",$emails)
} > C:\alias.txt