Still no love Karl...same error on each DB.  Still doesn't show MBX count or Disconnects

+     $disconnectedmailboxcount = Get-MailboxStatistics  <<<< -database "$mailboxpath"  |Where {$_.DisconnectDate -ne $
null} |measure-object
Get-MailboxStatistics : The specified mailbox database "CHMSG01\SG20DB\CHMSG01SG20DB1" does not exist.
At line:11 char:42

I did notice though that the code is referencing the DB path, not the name of the database;

PS C:\Scripts\Sydi> Get-Mailboxdatabase -server CHMSG01

Name                 Server
----                 ------
SYSADMIN01           CHMSG01
DEVELOPMENT01        CHMSG01
DEVELOPMENT02        CHMSG01
DEVELOPMENT03        CHMSG01
BACKOFFICE01         CHMSG01
BACKOFFICE02         CHMSG01
OPERATIONS01         CHMSG01
COMPLIANCE01         CHMSG01
EXECUTIVES01         CHMSG01
TRADERS01            CHMSG01
TRADERS02            CHMSG01
LONDON01             CHMSG01
OFFSHORE01           CHMSG01
SANFRAN01            CHMSG01
TOKYO01              CHMSG01
BACKOFFICE03         CHMSG01
DEVELOPMENT04        CHMSG01
DEVELOPMENT05        CHMSG01
TRADERS03            CHMSG01
CHMSG01SG20DB1       CHMSG01
EXECUTIVES02         CHMSG01

So after i specified the actual database name, your command does provide the mailbox count.  So it looks like I need to modify your code to look for DBname for the $mailboxcount variable.  I'll see if I can get it to work and post back. Thanks again

Got it working Karl; 

$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 $objItem |where {$_.DisconnectDate -eq $null -and $_.ObjectClass -eq 'Mailbox'} |Measure-Object
 $disconnectedmailboxcount = Get-MailboxStatistics -database $objItem  |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

All I did was change the "-database" references in the $mailboxcount and $disconnectedmailboxcount  variables to refer to the previously declared variable $objitem.  Works like a champ now!  Thanks alot dude.

This is a great script;

Hi Karl thanks for your great work. It helps me a lot to provision my 14 mailbox servers.
Can you add in more columns in the results? such as database mount status, last backup status, mailbox retention, prohibit send quota, prohibit sendreceive quota,issuewarningquota.

## http://powershellcommunity.org/Foru...fault.aspx
##

$exchangeservers = Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
$AllServers = @()
foreach ($server in $exchangeservers)
{
    $db = Get-MailboxDatabase -Status -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}" -f ($dbsize.Length/1024KB))
    $ReturnedObj | Add-Member NoteProperty -Name "Mailbox Count" -Value $mailboxcount.count
	$ReturnedObj | Add-Member NoteProperty -Name "LastFullBackup" -Value $objItem.LastFullBackup
	$ReturnedObj | Add-Member NoteProperty -Name "LastIncrementalBackup" -Value $objItem.LastIncrementalBackup
	$ReturnedObj | Add-Member NoteProperty -Name "BackupInProgess" -Value $objItem.BackupInProgess
	$ReturnedObj | Add-Member NoteProperty -Name "Mounted" -Value $objItem.Mounted          
	$ReturnedObj | Add-Member NoteProperty -Name "IssueWarningQuota" -Value $objItem.IssueWarningQuota              
    $AllServers += $ReturnedObj
    }
}

$AllServers

BTW. why

$exchangeservers = Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }

instead

$exchangeservers = Get-MailboxServer
?
 

cls
## http://powershellcommunity.org/Foru...fault.aspx
##

$exchangeservers = Get-MailboxServer 
#Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
$Jumbo = 1024 * 1024 
$AllServers = @()
foreach ($server in $exchangeservers)
{
    $db = Get-MailboxDatabase -Status -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    
	
	$DiskObj = get-WmiObject Win32_LogicalDisk -computerName $server | Where-Object { $_.DriveType -eq 3 -and $_.DeviceID -ieq  $objItem.EdbFilePath.DriveName}
	$FreeOnStorage = [int]($DiskObj.freespace / $Jumbo)
	$FreeOnStorageProc = [float](($DiskObj.freespace /$Jumbo) / ($DiskObj.size / $Jumbo))

    $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}" -f ($dbsize.Length/1024KB))
    $ReturnedObj | Add-Member NoteProperty -Name "Mailbox Count" -Value $mailboxcount.count
	$ReturnedObj | Add-Member NoteProperty -Name "LastFullBackup" -Value $objItem.LastFullBackup
	$ReturnedObj | Add-Member NoteProperty -Name "LastIncrementalBackup" -Value $objItem.LastIncrementalBackup
	$ReturnedObj | Add-Member NoteProperty -Name "BackupInProgess" -Value $objItem.BackupInProgess
	$ReturnedObj | Add-Member NoteProperty -Name "Mounted" -Value $objItem.Mounted          
	$ReturnedObj | Add-Member NoteProperty -Name "IssueWarningQuota" -Value $objItem.IssueWarningQuota    
	$ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendQuota" -Value $objItem.ProhibitSendQuota
	$ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota" -Value $objItem.ProhibitSendReceiveQuota
	$ReturnedObj | Add-Member NoteProperty -Name "MailboxRetention" -Value $objItem.MailboxRetention                                                  
	$ReturnedObj | Add-Member NoteProperty -Name "FreeOnStorage" -Value $FreeOnStorage 
	$ReturnedObj | Add-Member NoteProperty -Name "FreeOnStorageProc" -Value $FreeOnStorageProc   
    $AllServers += $ReturnedObj
    }
}

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

next version, including PF file.

## http://powershellcommunity.org/Foru...fault.aspx
## 

$AllServers = @()
  $mbdb = Get-MailboxDatabase -Status 
  $pfdb = Get-PublicFolderDatabase  -Status
  $db = $mbdb + $pfdb
  foreach ($objItem in $db)
  {
  $server=$objItem.ServerName
  $edbfilepath = $objItem.edbfilepath
  $path = "`\`\" + $objItem.ServerName + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2)
  $dbsize = Get-ChildItem $path    
  $DiskObj = get-WmiObject Win32_LogicalDisk -computerName $objItem.ServerName | Where-Object { $_.DeviceID -ieq  $objItem.EdbFilePath.DriveName }
  $FreeOnStorage = [int]($DiskObj.freespace / 1024KB)
  $FreeOnStorageProc = [float](($DiskObj.freespace /1024KB) / ($DiskObj.size / 1024KB))
  $start = $path.LastIndexOf('\')
  $dbpath = $path.Substring($start +1).remove($path.Substring($start +1).length -4)
  $mailboxpath = "$server\$dbpath"
  if($objItem.ObjectClass -ilike '*msExchPrivateMD*') { $mailboxcount = Get-MailboxStatistics -database "$mailboxpath" |measure-object } else { $mailboxcount = 0 }
  $ReturnedObj = New-Object PSObject
  $ReturnedObj | Add-Member NoteProperty -Name "DatabaseIdentity" -Value $objItem.Identity
  $ReturnedObj | Add-Member NoteProperty -Name "SizeMB" -Value ("{0}" -f ($dbsize.Length/1024KB))
  $ReturnedObj | Add-Member NoteProperty -Name "MailboxCount" -Value $mailboxcount.count
  $ReturnedObj | Add-Member NoteProperty -Name "LastFullBackup" -Value $objItem.LastFullBackup
  $ReturnedObj | Add-Member NoteProperty -Name "LastIncrementalBackup" -Value $objItem.LastIncrementalBackup
  $ReturnedObj | Add-Member NoteProperty -Name "BackupInProgess" -Value $objItem.BackupInProgess
  $ReturnedObj | Add-Member NoteProperty -Name "Mounted" -Value $objItem.Mounted          
  $ReturnedObj | Add-Member NoteProperty -Name "IssueWarningQuota" -Value $objItem.IssueWarningQuota    
  $ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendQuota" -Value $objItem.ProhibitSendQuota
  $ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota" -Value $objItem.ProhibitSendReceiveQuota
  $ReturnedObj | Add-Member NoteProperty -Name "MailboxRetention" -Value $objItem.MailboxRetention                                                  
  $ReturnedObj | Add-Member NoteProperty -Name "FreeOnStorage" -Value $FreeOnStorage 
  $ReturnedObj | Add-Member NoteProperty -Name "FreeOnStorageProc" -Value $FreeOnStorageProc   
  $AllServers += $ReturnedObj
  }

$AllServers | ft -AutoSize

Hey Karl, I have one more question.

Running Script:
$exchangeservers = @("Server1", "Server2")
$AllServers = @()
foreach ($server in $exchangeservers)
{
    $db = Get-MailboxDatabase -Status -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}" -f ($dbsize.Length/1024KB))
    $ReturnedObj | Add-Member NoteProperty -Name "Mailbox Count" -Value $mailboxcount.count
    $ReturnedObj | Add-Member NoteProperty -Name "LastFullBackup" -Value $objItem.LastFullBackup
    $ReturnedObj | Add-Member NoteProperty -Name "LastIncrementalBackup" -Value $objItem.LastIncrementalBackup
    $ReturnedObj | Add-Member NoteProperty -Name "BackupInProgess" -Value $objItem.BackupInProgess
    $ReturnedObj | Add-Member NoteProperty -Name "Mounted" -Value $objItem.Mounted
    $ReturnedObj | Add-Member NoteProperty -Name "MailboxRetention" -Value $objItem.MailboxRetention
    $ReturnedObj | Add-Member NoteProperty -Name "IssueWarningQuota" -Value $objItem.IssueWarningQuota
    $ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendQuota" -Value $objItem.ProhibitSendQuota
    $ReturnedObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota" -Value $objItem.ProhibitSendReceiveQuota
    $AllServers += $ReturnedObj   
    }
}

$ALLServers = $AllServers.Replace("@{","")
$ALLServers = $AllServers.Replace("}","`n")
function sendmail($body)
{
    $SmtpClient = new-object system.net.mail.smtpClient
    $MailMessage = New-Object system.net.mail.mailmessage
    $SmtpClient.Host = ""
    $mailmessage.from = "spamfree@domain.com"
    $mailmessage.To.add("user@domain.com")
    $mailmessage.Subject = “Exchange 2007 Database Sizes”
    $MailMessage.IsBodyHtml = $false
    $mailmessage.Body = $body
   
    $smtpclient.Send($mailmessage)
}

sendmail $ALLServers

but I'm getting an error:

Method invocation failed because [System.Object[]] doesn't contain a method nam
ed 'Replace'.
At C:\Program Files\Microsoft\Exchange Server\Scripts\mailboxstoresize.ps1:31 c
har:34
+ $ALLServers = $AllServers.Replace( <<<< "@{","")
Method invocation failed because [System.Object[]] doesn't contain a method nam
ed 'Replace'.
At C:\Program Files\Microsoft\Exchange Server\Scripts\mailboxstoresize.ps1:32 c
har:34
+ $ALLServers = $AllServers.Replace( <<<< "}","`n")
Exception calling "Send" with "1" argument(s): "Failure sending mail."
At C:\Program Files\Microsoft\Exchange Server\Scripts\mailboxstoresize.ps1:44 c
har:21
+     $smtpclient.Send( <<<< $mailmessage)

Thanks for your help.