Count mailboxes per database in Exchange with PowerShell

Sometimes you want to get a count of mailbox/mailboxes per database in Exchange. Find out how to get Exchange 2010/2013/2016/2019 mailbox count with PowerShell. But first, why do you need to get this information? For example, you want to distribute the mailboxes in the databases.

Mailbox count per database in Exchange with PowerShell

Let’s find the total mailboxes of each database. We are going to make use of the Get-Mailbox cmdlet. Run Exchange Management Shell as administrator.

[PS] C:\>Get-Mailbox -ResultSize Unlimited | Group-Object -Property:Database | Select-Object Name, Count | Sort-Object Name | Format-Table

Name Count
---- -----
DB01   235
DB02   249
DB03   292
DB04   437

It’s a great command if you want to know how many mailboxes are in each Exchange database.

Mailbox count of a specific database in Exchange

The previous command will count the mailboxes in all the databases. That’s great, but if you have a lot of databases it will take time. That is when you can decide to show the count of a specific database.

[PS] C:\>Get-Mailbox -ResultSize Unlimited -Database "DB01" | Group-Object -Property:Database | Select-Object Name, Count | Format-Table

Name Count
---- -----
DB01   235

It’s a great command if you want to know how many mailboxes are in a specific Exchange database.

Conclusion

In this article, you learned how to count mailboxes per database in Exchange with PowerShell. The mailbox count commands can be used in Exchange 2010/2013/2016/2019. The first command will list all the databases count in the organization. Run the second command if you only want to find the count of a specific database. Did you enjoy this article? You may also like Find Exchange version with PowerShell. Don’t forget to follow us and share this article.