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:

  1. Launch the Exchange Management Shell
  2. 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

  3. 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.
  4. Copy c:\exportsmtp.csv to a PC and open the file with Excel
  5. Press CNTL+F to bring up the FIND search box and enter the alias you a looking for.
  6. 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

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *