Solved

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

Posted on 2016-10-17
3
41 Views
Last Modified: 2016-10-20
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!
0
Comment
Question by:Rob Shorts
3 Comments
 
LVL 24

Expert Comment

by:-MAS
ID: 41846847
0
 
LVL 14

Accepted Solution

by:
Todd Nelson earned 500 total points
ID: 41847077
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
 

Author Closing Comment

by:Rob Shorts
ID: 41853037
Thank you!!!
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
how to add IIS SMTP to handle application/Scanner relays into office 365.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now