Mailbox statistics - Exchange 2010
Hi, I have an exchange 2010 sp1 server called EX01, that has 50 users and 5 mailbox databases. Is there a script I can use to get all the mailbox that reside on this server and include this information: Mailbox Name, Database and Mailbox size. Then can this be imported to a csv document. Is there a ps script available for me to achieve this? Thanks,Treadstone
May 2nd, 2011 10:50am

See below. http://www.petri.co.il/getting-mailbox-sizes-in-powershell.htm
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 11:11am

This should get you started. #Mailbox database - Get mailbox sizes and item counts for one server. Does not include disconnected or SystemMailbox mailboxes. Get-MailboxStatistics -Server EX01 | Where {$_.DisconnectDate -eq $null -AND $_.DisplayName -notlike "SystemMailbox*"} | Sort DatabaseName, DisplayName | FT -AutoSize DatabaseName, DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label=Size(MB)}, ItemCount > D:\Temp\ServerMB-Info.txt
May 2nd, 2011 11:12am

The below worked, but thanks guys! Get-MailboxStatistics -Server EX01 | fl Display Name,*size*,DatabaseName | Export-Csv 'file directory'.Treadstone
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 11:26am

That's going to give you disconnected and system mailboxes also. The FT (format-table) is easier to view for this type report than the FL (format-list) view.
May 2nd, 2011 11:43am

That's going to give you disconnected and system mailboxes also. The FT (format-table) is easier to view for this type report than the FL (format-list) view. Your correct, I'm no getting the using that again. Trying to see what I used exactly.Treadstone
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 11:57am

this is what I used: Get-MailboxStatistics -Server EX01 | ft DisplayName,*size*,DatabaseName | Export.Csv 'C:\Install\Test2'Treadstone
May 2nd, 2011 12:04pm

Sorry for going back-and-foth on this. This is what I used: Get-MailboxStatistics -Server EX01 | ft DisplayName,*size*,DatabaseName > 'C:\Install\Test2.txt' ApologiesTreadstone
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2011 6:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics