Report on size of everyones mailbox in the last 30 days in Exchange 2010?

I want to get a list of the size of every mailbox with active data (last 30 days), is there a way to do this via powershell?

Thanks!
Rob ShortsAsked:
Who is Participating?
 
Todd NelsonConnect With a Mentor Systems EngineerCommented:
Are you looking for a calculation of only the amount of data received within the past 30 days by all mailboxes; or are you asking for a list of mailboxes accessed in the last 30 days with their total mailbox sizes?

Assuming the latter...

If I understand what you are asking this command should provide you with the information you are requesting (displayed in the shell)...

Get-Mailbox | Get-MailboxStatistics | Where-Object {$_.Lastlogontime -ge (Get-Date).AddDays(-30)} | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount,LastLogonTime

Open in new window



If you need the info output to an CSV file that can be sorted in Excel, use this command...

Get-Mailbox | Get-MailboxStatistics | Where-Object {$_.Lastlogontime -ge (Get-Date).AddDays(-30)} | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount,LastLogonTime | Export-CSV "C:\MailboxSizes.csv" -NoTypeInformation

Open in new window


Let us know.
1
 
MAS (MVE)Technical Department HeadCommented:
0
 
Rob ShortsAuthor Commented:
Thank you!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.