Find specific SMTP address with PowerShell
How to find a specific SMTP address with PowerShell in the Exchange Organization? You want to know how many mailboxes are configured with a specific SMTP address. In this article, you will learn how to search and list mailboxes in Exchange Server with a specific SMTP address.
Do you want to list all SMTP addresses in the Exchange Organization? Read how to list all SMTP addresses with PowerShell »
Find specific SMTP address with PowerShell
We like to find mailboxes with a specific SMTP address in Exchange Server. These are the primary SMTP address and the secondary SMTP address, also known as alias address.
Run Exchange Management Shell as administrator. Run the cmdlet to list the mailboxes with that particular domain.
1 2 3 4 5 6 7 8 9 10 | [PS] C:\>Get-Mailbox -ResultSize Unlimited -Filter {EmailAddresses -Like "*@alitajran.com"} Name Alias ServerName ProhibitSendQuota ---- ----- ---------- ----------------- Administrator Administrator ex01-2016 Unlimited Ali Tajran alitajran ex01-2016 Unlimited Benetiz Anees Benetiz.Anees ex01-2016 Unlimited Boris Campbell boris.campbell ex01-2016 Unlimited Carl Kelly carl.kelly ex01-2016 Unlimited Christopher Payne christopher.payne ex01-2016 Unlimited |
Tweak the table view and add the information you need to the Select-Object cmdlet. For example, Name, PrimarySMTPAddress, and EmailAddresses.
1 2 3 4 5 6 7 8 9 10 | [PS] C:\>Get-Mailbox -ResultSize Unlimited -Filter {EmailAddresses -Like "*@alitajran.com"} | Select-Object Name, PrimarySMTPAddress, EmailAddresses Name PrimarySmtpAddress EmailAddresses ---- ------------------ -------------- Administrator Administrator@exoip.com {SMTP:Administrator@exoip.com, smtp:Administrator@alitajran.com, smtp:alias@microsoft.com, smtp:alias@contoso.com, smtp:Administrator@exoip.local} Ali Tajran Ali.Tajran@exoip.com {SMTP:Ali.Tajran@exoip.com, smtp:Ali.Tajran@alitajran.com} Benetiz Anees Benetiz.Anees@exoip.com {SMTP:Benetiz.Anees@exoip.com, smtp:Benetiz.Anees@alitajran.com} Boris Campbell Boris.Campbell@exoip.com {SMTP:Boris.Campbell@exoip.com, smtp:Boris.Campbell@alitajran.com} Carl Kelly Carl.Kelly@exoip.com {SMTP:Carl.Kelly@exoip.com, smtp:Carl.Kelly@alitajran.com} Christopher Payne Christopher.Payne@exoip.com {SMTP:Christopher.Payne@exoip.com, smtp:Christopher.Payne@alitajran.com} |
Another view to make it look a bit cleaner.
1 2 3 4 5 6 7 8 9 10 | [PS] C:\>Get-Mailbox -ResultSize Unlimited -Filter {EmailAddresses -Like "*@alitajran.com"} | Select-Object DisplayName,PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} DisplayName PrimarySmtpAddress EmailAddresses ----------- ------------------ -------------- Administrator Administrator@exoip.com {Administrator@alitajran.com, alias@microsoft.com, alias@contoso.com, Administrator@exoip.local} Ali Tajran Ali.Tajran@exoip.com Ali.Tajran@alitajran.com Benetiz Anees Benetiz.Anees@exoip.com Benetiz.Anees@alitajran.com Boris Campbell Boris.Campbell@exoip.com Boris.Campbell@alitajran.com Carl Kelly Carl.Kelly@exoip.com Carl.Kelly@alitajran.com Christopher Payne Christopher.Payne@exoip.com Christopher.Payne@alitajran.com |
Export to CSV file
We like to export the mailboxes with a specific SMTP address to CSV. This will export the CSV file to C:\temp\. Don’t forget to create a temp folder on the C drive or edit the export path.
1 | [PS] C:\>Get-Mailbox -ResultSize Unlimited -Filter {EmailAddresses -Like "*@alitajran.com"} | Select-Object DisplayName,PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV C:\temp\Specific_SMTP.csv -NoTypeInformation |
I hope it helped you to search and list the mailboxes that have a specific SMTP address configured.
Keep reading: How to bulk remove secondary SMTP address with PowerShell »
Conclusion
In this article, you learned how to find a specific SMTP address with PowerShell in Exchange Server. Run the cmdlet in PowerShell to get a list of the mailboxes with a specific SMTP address. Adjust the Select-Object cmdlet with the values you want to see. After that, export the list to CSV file and go through it.
Did you enjoy this article? You may also like Bulk create AD Users with random passwords. Don’t forget to follow us and share this article.
