Exchange 2007 Mailbox usage reporting – User and Server level

10 Jun

Exchange 2007 Mailbox usage reporting – User and Server level

Gotta impress your IT manager?? Do this… it will create quite an impression!!! :-)

Recently, I had to deal with a mailbox size limit request.
User says, “Increase my mailbox size limit to another 2 gigs.”

Now, don’t be harsh on him. Rather, prove and let him know how good he is managing/organizing his mailbox.

Let me show you on how to do that.

Start with:

[PS] C:\Windows\System32>Get-MailboxStatistics brucew | ft DisplayName,TotalItemSize,ItemCount

DisplayName TotalItemSize ItemCount

———– ……….————- ———

This cmdlet is going to show you the user mailbox is 5.39GB in size with over 150000 items.

Now run,

[PS] C:\Windows\System32>Get-MailboxfolderStatistics brucew | ft Name, ItemsInFolder, FolderSize >>C:\Ratish\brucew.txt

This cmdlet is going to show the Mailbox breakup by folder which is going to tell you what’s being consuming where? 99% times, you just have to tell the user to clean up his sent items or deleted items to gain couple of gigs free space.

It’s not a good practice to increase mailbox size limit coz down the line 6-8 months he is going to end up with very bad email experience with a huge mailbox and 100000+ items since his OST file keep growing, outlook stops responding, performance issue while switching from folder to folder etc.

Ok, now I know that Bruce Willis never cares to delete any of his emails…. What if I want to find this on a server level ??

Read on……………

Copy this and paste in a txt file:

Get-MailboxStatistics -server TypeServerNameHere | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(MB)”;expression={$_.TotalItemSize.Value.ToMB()}},storagegroupname,servername >C:\Output_MailboxReport.txt

Now, save the txt file to MailboxReport.ps1

Navigate to the shell and do this:

Now, all you need to do is to open the output (C:\Output_MailboxReport.txt) in Excel and sort users by high mailbox size and create a chart to showcase the top 10 users who are top contributors.

Leave a comment

Posted by on June 10, 2011 in Exchange


Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: