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