Exchange 2007 Mailbox Growth

So I was asked is there a way to see how your mailboxes grow (You know who you are!)  .. an interesting challenge for this time of the morning, but hey.

Here we go, this script uses Get-Mailbox and the does a fudge to get the date only part from the whencreated attribute and creates and array with the name,database and date.  It then sorts out and outputs the result

$xOut=@();$mbx | foreach{$obj=New-Object PsObject;$obj | Add-Member NoteProperty -Name “Mailbox” -Value $_.Name;$obj | Add-Member NoteProperty -Name “Database” -Value $_.Database;$x = $_.WhenCreated;$y=$x.date;$obj | Add-Member NoteProperty -Name “Date” $y;$xOut += $Obj};$xOut | sort date,database | group date,database | select count,name | ft -auto

Count Name
—– —-
    1 12/12/2008 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA
    1 17/12/2008 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA
    2 18/12/2008 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA
    1 07/01/2009 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA
    1 12/01/2009 00:00:00, DEVHC01First Storage GroupMailbox Database
    1 13/01/2009 00:00:00, DEVHC01First Storage GroupMailbox Database
   13 13/01/2009 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA
    1 14/01/2009 00:00:00, DEVHC01First Storage GroupMailbox Database
    1 14/01/2009 00:00:00, DEVMB01-VASG01-DEVMB01-VADB01-SG01-DEVMB01-VA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: