Getting Mailbox Statistics from a select group of users

I’m working a project where they’re targeting a pilot group of users for mailbox quota information, and I was requested to put together a Powershell command that allowed them to put together a list of users, gather some information on each one regarding their mailbox usage, and dump that report out to a CSV. Well, it look a little bit of work, trial & error, plus all round Googling, but I’ve come up with the gem that works.

Your input CSV, list.csv, needs only to be 1 column with Row 1 titled Name and the remaining rows as the first/last name of the users you want to gather information on.

Save this file below as report.ps1, and fire it up:

Import-Csv “c:\list.csv” | ForEach-Object -Process {Get-Mailbox $_.Name | Select-Object name,@{n=”Size(MB)”;e = {$MBXstat = Get-MailboxStatistics $; $MBXstat.totalItemsize.value.toMB()}},@{n=”DeletedSize(MB)”;e = {$MBXstat = Get-MailboxStatistics $; $MBXstat.totalDeletedItemsize.value.toMB()}},@{n=”Items”; e = {$MBXstat = Get-MailboxStatistics $ ; $MBXstat.itemcount}},@{n=”DeleteItems”; e = {$MBXstat = Get-MailboxStatistics $ ; $MBXstat.deleteditemcount}}} | Export-CSV “c:\userstats.csv” -notype

You’ll be able to pull the the total items, both in the mailbox and deleted items dumpster, as well as the size of the mailbox plus deleted items dumpster. If you want to add more rows from either the Get-Mailbox or Get-MailboxStatistics command, its pretty straight forward!

Chris Blackburn

Learn More →

One thought on “Getting Mailbox Statistics from a select group of users

  1. Reporting Mailbox Sizes on Microsoft Exchange 2010 | Curiosity killed the cat June 17, 2013 at 1:12 pm

    […] (the example was taken from Memphis Technical Network site) […]


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.