UPDATE: Mar 26, 2020 for Exchange ONLINE instructions we have How To Export All Email Addresses and Alias to A File From Office365 Exchange Online HERE.
If you have ever been asked who has a particular email alias on an Exchange server, you know you in for trouble because the answer is not readily apparent in the Exchange Management Console.
The easiest way I know to find alias names in Exchange is to use the PowerShell Script below to export all the alias’ to a CSV:
- Launch the Exchange Management Shell
- Copy and Paste the following script into the shell:
Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,PrimarySmtpAddress, @{Name=”EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\exportsmtp.csv -NoTypeInformation
- Wait a few minutes. The more email accounts you have the longer it will take. In my case it scanned through about 2000 accounts and exported the results in 3 minutes.
- Copy c:\exportsmtp.csv to a PC and open the file with Excel
- Press CNTL+F to bring up the FIND search box and enter the alias you a looking for.
- The first column contains the root email account that the alias is attached to
A special thanks to Patrick Burgman from www.SmartTowns.ca for digging out this script. Shabbat Shalom Patrick.
Enjoy!
2 Comments
David · November 13, 2015 at 6:08 am
Does Get-Recipient not work for you?
Ian Matthews · December 27, 2015 at 4:37 pm
That is an option but I found this better for my purpose. Thanks