With the following script you can create an overview of all users in the different storage groups. Handy to see how many mailboxes you have in your Exchange 2007 environment 😉
__________________________________
###
clear-host
write-host -fore yellow “This script will get each mailboxdatabase and the current user count ”
foreach($name in get-mailboxdatabase)
{
write-output “$name”
$count=(get-mailbox -database $name).count
if($count -eq $null)
{ write-host -fore red “Empty Database, no users”
}
else
{ write-output $count }
}
write-host -fore yellow “The system has a total of “$user=(get-mailbox -resultsize:unlimited).count
write-host -fore red $user
__________________________________
The output of this script you can see below: