Hi Folks I borrowed this script from your community to extract the number of mailboxes in our environment and it reported errors, pasted below:
Get-MailboxStatistics : The specified mailbox database "ServerName\MailDatabase 1" is not unique. At line:12 char:38
Get-ChildItem : Cannot find path '\\ServerName\H$\Store1718\SG17\MailDatabase1. edb' because it does not exist.

Script as executed:::
## PowerShell.exe -PSConsoleFile "C:\Program Files\Microsoft\Exchange Server\Bin\ExShell.psc1" -Command ". 'C:\Program Files\Microsoft Identity Integration Server\MaData\count2.ps1'"
$MailboxCount = "C:\Program Files\Microsoft Identity Integration Server\MaData\MailboxCount.csv" $exchangeservers = Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
$AllServers = @()
foreach ($server in $exchangeservers)
{ $db = Get-MailboxDatabase -server $server foreach ($objItem in $db)
{ $edbfilepath = $objItem.edbfilepath $path = "`\`\" + $server + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2)
 $dbsize = Get-ChildItem $path $start = $path.LastIndexOf('\') $dbpath = $path.Substring($start +1).remove($path.Substring($start +1).length -4)
$mailboxpath = "$server\$dbpath"
 $mailboxcount = Get-MailboxStatistics -database "$mailboxpath" |measure-object
$ReturnedObj = New-Object PSObject
$ReturnedObj | Add-Member NoteProperty -Name "Server\StorageGroup\Database" -Value $objItem.Identity
#$ReturnedObj | Add-Member NoteProperty -Name "Size (MB)" -Value ("{0:n2}" -f ($dbsize.Length/1024KB))
$ReturnedObj | Add-Member NoteProperty -Name "Mailbox Count" -Value $mailboxcount.count $AllServers += $ReturnedObj } }

$AllServers |export-csv c:\testcount.csv -notype -force

We have 6 clustered servers across which our mailbox database is stored.

This script does much more than calculating the number of mailboxes in the env.

Instead you just try running below command to get number of mailboxes in your env. or let us know what is your exact requirement.

(Get-mailbox -resultsize Unlimited).count

Thanks.

Hi Vishal

I have been assigned the task to write a script which reports the number of mailboxes in our environment. The script should poll the exchange database and send an email to a monitoring mailbox on the total number of mailboxes.

Another requirement is when the mailboxes have exceeded 96000 it should stop the creation of mailboxes in our exchange environment.

I have been trying to find all the resources on internet to accomplish, any help on this would be greatly appreciated.

Best Regards
Justin

$count = (get-mailbox -resultsize unlimited).count

.....

$mail.subject = "There are $count number of mailboxes in the environment"
http://www.powershellpro.com/powers...lerts/210/ ##link describes sending an email through PS.

.....

set up a rule in the monitoring mailbox that say once the it see's a message with 96000 in the subject... forward it to you...

then, once you see that message, go and strip the permissions that allow people to create new mailboxes...
probably a PS solution to do it all, but this just seems the simplest...

Thanks
Pres.

Hi Folks

script pasted below did the job for me!! thanx for ur time!

####################################################################


$exchangeservers = Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
$AllServers = @()
foreach ($server in $exchangeservers)
{
$db = Get-MailboxDatabase -server $server
foreach ($objItem in $db)
{

$mailboxcount = Get-MailboxStatistics -database $objItem |measure-object
$ReturnedObj = New-Object PSObject
$ReturnedObj | Add-Member NoteProperty -Name "Server\StorageGroup\Database" -Value $objItem.Identity
$ReturnedObj | Add-Member NoteProperty -Name "Mailbox Count" -Value $mailboxcount.count
$AllServers += $ReturnedObj
}
}

$AllServers |export-csv c:\MailboxCount.csv -notype -force

please note the script is the same as posted in my write up on 14 Jun 2010 10:47 AM

How about

Get-MailboxServer | Get-MailboxDatabase | Get-MailboxStatistics | Group-Object Database -NoElement