I am having the same problem on my 2008 cluster, i would love to know how you end up getting around this issue and can use the script.

Thanks
TT

Hi sumovato,

Sorry to hear...but I'm kinda glad that it actually appears to be an 2008 cluster feature. I only need for the script to work for our 2008 clusters (not mixed 2003 and 2008), so I pretty much specified what my two passive nodes are (because I can map d$ by using cluster node names instead cluster names), and added another layer of "foreach" logic to deal with this new setup.

Here's how it looks like:

$passivenodes = "node1", "node2"
$Allservers = @()
foreach ($node in $passivenodes) 
      { if ($node -eq "node1") 
            { $db = Get-MailboxDatabase -server  cluster1name
                  foreach ($objItem in $db) 
                     { $path = "`\`\" + $node + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2) 
                     $dbsize = Get-ChildItem $path 
                     $ReturnedObj = New-Object PSObject 
                     $ReturnedObj | Add-Member NoteProperty -Name "PathName" -Value $objItem.Identity
                     $ReturnedObj | Add-Member NoteProperty -Name "Size (MB)" -Value ("{0:n2}" -f ($dbsize.Length/1024))       
                     $AllServers += $ReturnedObj } } 

      else 
            {$db = Get-MailboxDatabase -server cluster2name  
                  foreach ($objItem in $db) 
                      { $path = "`\`\" + $node + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2) 
                        $dbsize = Get-ChildItem $path $ReturnedObj = New-Object PSObject 
                        $ReturnedObj | Add-Member NoteProperty -Name "PathName" -Value $objItem.Identity.tostring() 
                        $ReturnedObj | Add-Member NoteProperty -Name "Size (MB)" -Value ("{0:n2}" -f ($dbsize.Length/1024)) 
                        $AllServers += $ReturnedObj } } }

$Allservers


---

Hope that helps someone... I would still like to know how to simplify it and use the cluster names as in the original script.

This script is working perfectly against our Windows 2008 clusters. Would it be possible to include the whitespace info for each database?

Thanks!

Hm, I think you can only check the whitespace of the database by using eseutil utility.

I suppose execution of eseutil could be incorporated into the script, in both foreach sections of the script, but eseutil has it's own output... not sure how that could be captured by powershell and customized.  I think it could be possible, but it would complicate the script, and possibly require additonal .net programming.

Sorry, not very helpfull resonse, but maybe it can point you in the right direction.

ST

Here's what i use for the db's


Get-MailboxDatabase -Server $Target -Status | Select Server, Mounted, @{n='MailboxeCount';e={@(Get-Mailbox -database $_.identity).count}}, LastFullBackup, StorageGroup, Name, @{Name="Size";Expression={$objitem = (Get-MailboxDatabase $_.Identity); $path = "`\`\" + $objitem.server + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2); $size = ((Get-ChildItem $path).length)/1048576KB; [math]::round($size, 2)}} | Sort-Object Name


White space is this one

#function Get-ExchangeWhiteSpace {

#param(
$ComputerName = $Target
#$(throw "ComputerName cannot be empty.")
#)

# Convert Dates to WMI CIM dates
$tc = [System.Management.ManagementDateTimeconverter]
$Start =$tc::ToDmtfDateTime( (Get-Date).AddHours(-24).Date)
#Days(-1).Date )
$End =$tc::ToDmtfDateTime( (Get-Date).Date)

# Create two claculated properties for InsertionStrings values
$DB = @{Name="DB";Expression={$_.InsertionStrings[1]}}
$FreeMB = @{Name="FreeMB";Expression={[int]$_.InsertionStrings[0]}}

$colWhiteSpace = Get-WMIObject Win32_NTLogEvent -ComputerName $Target -Filter "LogFile='Application' AND EventCode=1221 AND TimeWritten>='$Start' AND TimeWritten<='$End'" | Select-Object ComputerName,$DB,$FreeMB | Sort-Object FreeMB –Descending

Awesome work! This has helped me greatly!

I have a very large Global Exchange Enviroment and I am trying to add some additional information:

1. Whitespace on every Storage Group

If actual Whitespace can't be obtain directly..what are the possiblity of getting a column showing the total database size based on the size of each mailbox within that storage group?

Then that could be subtracted from the physical size of the database to get you a rough whitespace listing correct?  I've tried some scripts that attempt to extract the whitespace from the application logs but never gotten any of those to work well.

2. Number of Disconnected Mailboxes in each Storage Group

3. Number of Disabled users with mailboxes (not counting resource mailboxes..room,shared,equipment ones) in each Storage Group

4. Total size of the mailboxs being used in 2 and 3

Thanks,
Urlryn

Urlryn;

Have a llok at my blog post for #1
http://unlockpowershell.wordpress.c...ng-script/

For #2, see the script in post 6 (from me) on page 3 of this thread beginning "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 will see if I can devote some time to 3 and 4, but I am up way past my eyeballs in a server inventory project at the moment.

Karl

Take your time karl!

We all appreciate the hard work you put into doing these scripts!

In the meantime I will def check out those other posts you suggested!
And sorry for the delay in getting back to ya!

Urlryn

This is an amazing script with some great potential.  I just seem to come up with errors, sadly, everytime I run it.  I have configured it 7 different ways from Sunday and for the life of me can't get it to pick the individual servers in the cluster.  (exchange 2007, server 2008 r2)

I have two nodes "svr-exch1"and "svr-exch2" which make up "clstr-exchmail".

the first error that pops up is
Get-children : Cannot find path '\\clstr-exchmail\f$\program files... etc. etc. etc. because it does not exist. 

so I tried to set $exchangeservers = "svr-exch1" ....no go

I have grabbed almost every script in this thread and still haven't been able to get them to work.

But then I found your one liner....

Get-MailboxServer | Get-MailboxDatabase | Select Server, StorageGroupName, Name, @{Name="Size";expression={"{0:N2}" -f ((get-mailboxstatistics -database $_.Identity | Measure-Object -Property TotalItemSize,TotalDeletedItemSize -Sum |Select-Object Sum |Measure-Object -Property Sum -Sum).Sum.ToString() /1mb)}} 

 And it worked great!!!  But now, I want to figure out how to incorporate # of mailboxes and whitespace into it somehow.  I just don't understand how the one liner works and can get me the info in a great table....but the ps1 will not.

Thanks for all your hard work.  You make our lives so much easier.

I do this with one fancy line of code.

# Load the Exchange 2007 snap-in if they are not already loaded
Add-PSSnapIn -Name Microsoft.Exchange.Management.PowerShell.Admin -ErrorAction SilentlyContinue

# Work the MAGIC!
Get-MailboxServer | Get-MailboxDatabase | Select Identity, @{Name="Size";expression={"{0:N2}" -f ((get-mailboxstatistics -database $_.Identity | Measure-Object -Property TotalItemSize,TotalDeletedItemSize -Sum |Select-Object Sum |Measure-Object -Property Sum -Sum).Sum.ToString() /1mb)}} | Sort Server, Identity | Export-Csv d:\ExchMetrics\DatabaseSumSize_$(get-date -f MM_dd_yyyy).csv -notype

Hi Karl

I borrowed your script 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.

Hey Karl

I don't know if this topic is closed or visited anymore, but I'm having a difficult time trying to get a script to work for me that should be relatively simple

I've tried adapating the scripts I found on here to some degree of success but not ever quite right. Not sure if its something I'm doing. I'm no pro at scripting. Just did a few here and there.

We have 2 mailstore servers, however I only need the information specifically for the 1st/primary mailstore. The second mailstore is a replication server as a backup incase of power failure and is stored at another site.

The information I'm looking for is:

1) The total allocated size of each mailbox store (Just want to know how much space was allocated for each store)
2) The amount of space used for each store
3) The amount of free space for each store

Not not concerned about individual mailboxes as I have a script already that reports back bi-weekly on individual mailboxes so that I can get people to setup auto-archiving.



Speaking of Server Inventoring, we are in the process of doing the same thing here. We're using a GPL product called OCS. Doesn't seem to shabby.  We use it to inventory all our servers, and all deployed desktops and laptops. It reports back at various periods, or it can be called manually, to a centralised server. The results are viewable in a webinterface. Quite nifty. We can even manually add inventory for those things that can't be auto-detected (ie: monitors, printers, desks, cabinets, switches etc). Currently intentegrated into our ticketing system (GLPI) so that we can track issues and if it turns out to be hardware related, we can easily deploy a new system with similar stats, and have a list of all the software on that system.

Davide,

Not sure what you're asking for in number 1.

Also, you should seriously reconsider the auto-archive thing. PST files are, or will be your biggest nightmare. Exchange 2007 doesn't need a lot of IO, I think you'd be better off putting some sata disks in one of your servers and keeping mail on that.

Hi Justin;

Does \\ServerName\H$\Store1718\SG17\MailDatabase1.edb' exist?

Are you using mount points?
If so, see my blog post:
http://unlockpowershell.wordpress.c...ng-script/

Karl

Davide;

So, you only have 1 exchange server to worry about?

Karl

Hi Karl,

Yur script is rocking but with one thing I am really struggling from last 4 days !!! :( :(

By taking clue from your script I have written this smalll script:

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


{
$diskinfo=Get-wmiobject -computer $server -class win32_volume -filter "drivetype=3" | select-object Name,label , @{Name="Capacity";Expression={[math]::round($_.Capacity/1GB,2)}}, @{Name="free_space (GB)";Expression={[math]::round($_.freespace/1GB,2)}},@{Name="free_percentage";Expression={[math]::round(([INT64]$_.FreeSpace/[INT64]$_.Capacity)*100,2)}}


foreach ($objItem in $diskinfo)

{


$ReturnedObj = New-Object PSObject

$ReturnedObj | Add-Member NoteProperty -Name ("Name") -Value $objItem.name
$ReturnedObj | Add-Member NoteProperty -Name ("label") -Value $objItem.Label
$AllServers += $ReturnedObj
}
}

$AllServers |Export-Csv c:\exchtest\new.csv -notype -force

and I get result like this :

Name label
C:\ OS
D:\ New Volume
E:\ New Volume
F:\ Database1
G:\ Logs1
H:\ Database2
I:\ Logs2
J:\ Database3
K:\ Logs3
C:\
E:\ New Volume

Now what I want is likethis :

Server name is srver1 and role is : Mailbox
Name label
C:\ OS
D:\ New Volume
E:\ New Volume
F:\ Database1
G:\ Logs1
H:\ Database2
I:\ Logs2
J:\ Database3
K:\ Logs3

Server name is srver2 and role is : HUB
Name label
C:\
E:\ New Volume

Pleae let me know how to accomplish this as this would help me in formatting of my future scripts as well

Hey Karl..hate reviving a older thread...but where is the best place to be post about your scripts now that you go them on here, wordpress, and Powershell Repository.

I've been trying to get your scripts to run...and i just don't have any darn luck with any of them.

http://unlockpowershell.wordpress.c...ng-script/

http://unlockpowershell.wordpress.c...ng-script/

and even some on this thread!  Its driving me nuts.

Where exactly are we supposed editing these files? if at all!

If I run the 07 to 10 reporting script i get this:

Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'lastIndexOf'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:40 char:73 + $letter = $drive.EdbFilePath.Substring(0,$drive.EdbFilePath.lastIndexOf < <<< ("\")) + CategoryInfo : InvalidOperation: (lastIndexOf:String) [], Runti meException + FullyQualifiedErrorId : MethodNotFound

You cannot call a method on a null-valued expression. At M:\Exchange Mailbox size\ps_scripts\db_report3.ps1:41 char:39 + $DatabaseSizeHash.Add($letter.TrimEnd <<<< ("\"),$VolumeCapacityHash[$let ter]) + CategoryInfo : InvalidOperation: (TrimEnd:String) [], RuntimeEx ception + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:42 char:39 + $DatabaseFreeHash.Add($letter.TrimEnd <<<< ("\"),$VolumeHash[$letter]) + CategoryInfo : InvalidOperation: (TrimEnd:String) [], RuntimeEx ception + FullyQualifiedErrorId : InvokeMethodOnNull

Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'Split'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:131 char:70 + $path = "`\`\" + $ServerName + "`\" + $objItem.EdbFilePath.Split <<<< (" :")[0] + "$"+ $objItem.EdbFilePath.Split(":")[1] + CategoryInfo : InvalidOperation: (Split:String) [], RuntimeExce ption + FullyQualifiedErrorId : MethodNotFound

Hello;

You should generally post questions about the wcript where you find the script :)

Try changing line 40 as follows:
$letter = $drive.EdbFilePath.Substring(0,$drive.EdbFilePath.ToString().LastIndexOf(“\”))

Try changing line 131 as follows:
<code>
$path = "`\`\" + $ServerName + "`\" + $objItem.EdbFilePath.Split(":")[0] + "$"+ $objItem.EdbFilePath.ToString().Split(":")[1]
<code>

Karl

Hey Karl,
This is the error now after adding your changes.


Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'Substring'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:40 char:40 + $letter = $drive.EdbFilePath.Substring <<<< (0,$drive.EdbFilePath.ToStrin g().LastIndexOf("\")) + CategoryInfo : InvalidOperation: (Substring:String) [], Runtime Exception + FullyQualifiedErrorId : MethodNotFound

You cannot call a method on a null-valued expression. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:41 char:39 + $DatabaseSizeHash.Add($letter.TrimEnd <<<< ("\"),$VolumeCapacityHash[$let ter]) + CategoryInfo : InvalidOperation: (TrimEnd:String) [], RuntimeEx ception + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:42 char:39 + $DatabaseFreeHash.Add($letter.TrimEnd <<<< ("\"),$VolumeHash[$letter]) + CategoryInfo : InvalidOperation: (TrimEnd:String) [], RuntimeEx ception + FullyQualifiedErrorId : InvokeMethodOnNull

Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'Split'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:131 char:70 + $path = "`\`\" + $ServerName + "`\" + $objItem.EdbFilePath.Split <<<< (" :")[0] + "$"+ $objItem.EdbFilePath.ToString().Split(":")[1] + CategoryInfo : InvalidOperation: (Split:String) [], RuntimeExce ption + FullyQualifiedErrorId : MethodNotFound

Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'Split'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:133 char:40 + $dbpath=(Split-Path $edbfilepath.Split <<<< (":")[1] -Leaf).trimend(".edb ") + CategoryInfo : InvalidOperation: (Split:String) [], RuntimeExce ption + FullyQualifiedErrorId : MethodNotFound

Method invocation failed because [Microsoft.Exchange.Data.EdbFilePath] doesn't contain a method named 'Split'. At M:\Exchange Mailbox Size\ps_scripts\db_report3.ps1:136 char:50 + $mailboxpath = $ServerName + $edbfilepath.Split <<<< (":")[1].trimend (".edb") + CategoryInfo : InvalidOperation: (Split:String) [], RuntimeExce ption + FullyQualifiedErrorId : MethodNotFound

Thanks again,

Urlryn

Am I also working with you on the blog?

If so, let's take this offline.

I will modify my blog post/

Karl

Hey Karl,

Nope! I haven't posted anything at your blog! I didn't want to start confusing you with multiple posts everywhere!
We can move it offline or to your blog or whatever! I'm at your mercy! :)

Thanks,
Urlryn

I postred a new version on my blog.

hi Karl,

Indeed this is a good script, but i ran into error when trying to run the script is give me error on Get-MailboxStatistics : The specified mailbox database "TESTLABCCR01\TL01DB\TESTLABCCR01_TL01DB" does not exist.
At D:\PowerShellScripts\countallMB.ps1:13 char:39
+ $mailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpath" |Wh
ere {$_.DisconnectDate -eq $null -and $_.ObjectClass -eq 'Mailbox'} |measure-ob
ject

where else my database is TESTLABCCR01\TL01\TL01DB

can kindly advice on this? Thank you.

Posted By KarlMitschke on 28 Jul 2010 08:17 AM
I postred a new version on my blog.

Hi Karl, I have Exchange Mgmt tools installed on my windows7 machine, I can run a : "get-mailboxstatistics -identity username" and it will display the statistics for that mailbox, but when I try to run the script you have given on page-1 of this thread it will throw the following error : ------ Get-MailboxStatistics : The specified mailbox database "MYExchangeServerNAME\FirstStorageGroup\Mailbox Database" does not exist. ------ Will be grateful for your assistance on this Kind Regards