Exchange Server Mailbox Statistics Report
Managing the Exchange Servers in storage capacity is a little bit difficult for administrators when the server gets older and older and when new users are added on the list.
Even if there is any daily monitoring report for mail flow, databases, disk space monitoring and everything it's still difficult for administrators to monitor end users that have a lot of old emails in their inbox which occupies a lot of space.
It would be better if there were a statistics report that can pull out the number of mailbox items and oldest messages for all users so that we can ask the users to move old items to their PST archives.
There are lots of scripts available on the internet which can run on the mailbox server DBs to pull out this information.
There is this excellent tool developed by author Srinath Sadda and it's available in the TechNet gallery for download: http://gallery.technet.microsoft.com/office/Exchange-Server-Mailbox-7dd53529
The interesting part about this tool is that it doesn't need PowerShell or EMS. It's a GUI-based tool which can be run manually whenever required.
This tool can be run for a single mailbox, particular database as well as for all mailboxes in a server.
It was tested in a lab and its working fine. Below are the results.
Downloaded the tool from the TechNet gallery (source file link above) and installed.
Once the installation is complete, open the tool and you will get the below screen.
Now we need to specify the DC, Exchange server and DBs. If we select Retrieve it fetches the above information automatically. Select the oldest and newest items accordingly and click on Perform Mailbox Search.
Finally, once the report is complete you can click on the Report Viewer.
Below is the final report status.
We have an option to send this report through email as well.
Apart from this, we have multiple options like searching for mailboxes globally that are hidden from GAL, Number of Disabled mailboxes , Mailbox Type, and a few more options.
This tool is very useful in terms of monitoring the mailbox statistics for individual users as well as all users.