View number of mailboxes per database

This gives you a count of all mailboxes per database, useful for planning mailbox creation.
Get-Mailbox -ResultSize:Unlimited | Group-Object -Property:Database | Select-Object Name,Count | Sort-Object -Property:Count -Descending

Here is a filter example for showing only the users in a specific database:
Get-Mailbox -ResultSize:Unlimited | Group-Object -Property:Database | Select-Object Name,Count | Sort-Object -Property:Count -Descending | where {$_.Name -like "*<Part of Database Name>*"}

About these ads