OK, I know this should not be hard but I am at a loos on how to do this.  How do I accurately report on the size of the Exchange 2007 mailbox database?  I can of course take the size of everyones mailbox and sum it, but the size this reflects does not seem to show the real DB size.  And I would rather not just take the file size (free space and all that).

How about to kick out to a csv file?  I'd like to import this into SQL but am beating my head on the wall trying to output the text untruncated in a nice csv format.  I'm not certain where I can add the pipe for export-csv.  Any help would be great!

Excellent script :)

Thanks!

Perfect!

Thanks :)

Thanks!

Any idea on this error:

Get-MailboxStatistics : Cannot bind parameter 'Database'. Cannot convert value
"EX2007D\Program Files\Microsoft\Exchange Server\Mailbox\Fifth Storage Group\Ma
ilbox Database 5" to type "Microsoft.Exchange.Configuration.Tasks.DatabaseIdPar
ameter". Error: "'EX2007D\Program Files\Microsoft\Exchange Server\Mailbox\Fifth
 Storage Group\Mailbox Database 5' is not a valid value for the identity.
Parameter name: Identity"
At C:\scripts\database_size3.ps1:16 char:52
+     $mailboxcount = Get-MailboxStatistics -database  <<<< $mailboxpath |measu
re-object

It seems to not like the -database option for some reason...

Here you go.  I'm only listing one storage group result per variable but it does return these results for each database:

$server=EX2007D

$db=Mailbox Database     EX2007D         First Storage Group  False
Mailbox Database 3   EX2007D         Third Storage Group  False
Mailbox Database 4   EX2007D         Fourth Storage Group False
Mailbox Database 5   EX2007D         Fifth Storage Group  False

$edbpath=IsPathInRootDirectory : False
PathName              : C:\Program Files\Microsoft\Exchange Server\Mailbox\Fift
                        h Storage Group\Mailbox Database 5.edb
IsLocalFull           : True
IsUnc                 : False
DriveName             : C:
ServerName            :

$path=\\EX2007D\C$\Program Files\Microsoft\Exchange Server\Mailbox\Fifth Storage Grou
p\Mailbox Database 5.edb

$mailboxpath=EX2007D\Program Files\Microsoft\Exchange Server\Mailbox\Fifth Storage Group\Mai
lbox Database 5

Thanks!

get-mailboxstatistics -database "EX2007D\Program Files\Microsoft\Exchange Server\Mailbox\Fifth Storage Group\Mailbox Database 5"   gives me the error in the previous post.

get-mailboxstatistics -database "EX2007D\Mailbox Database 5" Works!

Could a variable be defined for just the database name?

Thanks!

Try replacing the line

$mailboxcount = Get-MailboxStatistics -database "$mailboxpath"  |measure-object

With this one:

$mailboxcount = Get-MailboxStatistics -database "$mailboxpath"  |Where {$_.DisconnectDate -eq $null} |measure-object

Karl

I saw an emailed question from mdgray asking: "Could the same code be used to leave out the System Mailboxes as well as the disabled accounts?"
I don't see the question here, anymore, but:

$mailboxcount = Get-MailboxStatistics -database "$mailboxpath"  |Where {$_.DisconnectDate -eq $null -and $_.ObjectClass -eq 'Mailbox'} |measure-object

My whole script is now:

##############################################################
#                                                            #
# Script to show the size and mailbox count of all databases #
#                                                            #
#                Karl Mitschke 4/9/2008                      #
#                                                            #
##############################################################

$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
	$dbpath = $EdbFilePath.PathName.Remove(0,2).remove($EdbFilePath.PathName.length-6)
	$mailboxpath = "$server$dbpath"
	$mailboxcount = Get-MailboxStatistics -database "$mailboxpath"  |Where {$_.DisconnectDate -eq $null -and $_.ObjectClass -eq 'Mailbox'} |measure-object
	$disconnectedmailboxcount = Get-MailboxStatistics -database "$mailboxpath"  |Where {$_.DisconnectDate -ne $null} |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 "User Mailbox Count" -Value $mailboxcount.count
	$ReturnedObj | Add-Member NoteProperty -Name "Disconnected Mailbox Count" -Value $disconnectedmailboxcount.count
    $AllServers += $ReturnedObj
    }
}

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

Karl,

Thanks for the script, however I am not seeing User Mailbox Count or Disconnected Mailbox Count in my output?  I get the DBs and DB size just fine.  It appears as though my path is being truncated for some reason.

"Get-MailboxStatistics : The specified mailbox database "CHMSG03\SG3DB\CHMSG03SG3DB1" does not exist.
At line:12 char:54"

The actual path is "CHMSG03\CHMSG0SG3DB\CHMSG03SG3DB"

 Any thoughts?  Thanks

Garion

Thanks Karl!  My mistake, these are the correct paths as verified by the output from your command and a quick visual;

F:\SG3DB\CHMSG03SG3DB1.edb

F:\SG1DB\CHMSG03SG1DB1.edb

F:\SG2DB\CHMSG03SG2DB1.edb

F:\SG4DB\CHMSG03SG4DB1.edb

F:\SG5DB\CHMSG03SG5DB1.edb

F:\SG6DB\CHMSG03SG6DB1.edb

F:\SG7DB\CHMSG03SG7DB1.edb

F:\SG8DB\CHMSG03SG8DB1.edb

F:\SG9DB\CHMSG03SG9DB1.edb

F:\SG10DB\CHMSG03SG10DB1.edb

F:\SG11DB\CHMSG03SG11DB1.edb

F:\SG12DB\CHMSG03SG12DB1.edb

F:\SG13DB\CHMSG03SG13DB1.edb

F:\SG14DB\CHMSG03SG14DB1.edb

F:\SG15DB\CHMSG03SG15DB1.edb

F:\SG16DB\CHMSG03SG16DB1.edb

F:\SG17DB\CHMSG03SG17DB1.edb

F:\SG18DB\CHMSG03SG18DB1.edb

F:\SG19DB\CHMSG03SG19DB1.edb

F:\SG20DB\CHMSG03SG20DB1.edb

F:\SG21DB\CHMSG03SG21DB1.edb

I'm not getting any other errors other than these for each DB so I'm not sure why I'm not getting the MBX count and Disconnected count;

 At line:12 char:54
+     $disconnectedmailboxcount = Get-MailboxStatistics  <<<< -database "$mailboxpath"  |Where {$_.DisconnectDate -ne $
null} |measure-object
Get-MailboxStatistics : The specified mailbox database "CHMSG02\SG1DB\CHMSG02SG1DB1" does not exist.