Solved

Get mailbox size on Exchange 2010

Posted on 2014-12-03
6
230 Views
Last Modified: 2014-12-03
Hi experts,

Anyone know a easy way to get mailbox size from an Exchange database please?

We are using Exchange 2010 and only have ONE database. I have tried some script I downloaded but that didn't work (I tried CompareMailboxSize script) and I am currently trying the Exchange Server Mailbox Statistics Tool. It started fine but seems to stuck somewhere towards the end.

Admittedly we do have some large mailboxes well over 5GB (each!) Maybe it is taking its time but it is frustrated not seeing the Overall Progress bar moving!

I have also tried this script from Spiceworks (?)  - Get-MailboxStatistics -Database "Mailbox Database XXXXXXXXXXXXX" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\MBSizes.csv

However when I replaced xxxxxxxxx with the Database name, upon running it flashes but did nothing.

Please could anyone shred some light?

Thank you in advance.
0
Comment
Question by:ormerodrutter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 24

Accepted Solution

by:
VB ITS earned 300 total points
ID: 40478289
The Spiceworks command you ran exports the result of the command to a CSV file. Look in the C: drive on the server that you ran this command for a file named MBSizes.csv and open it in Notepad - you should see the mailbox sizes in this file.
0
 
LVL 23

Author Comment

by:ormerodrutter
ID: 40478301
No that didn't. I have searched the entire C:\ drive and nothing.
0
 
LVL 24

Expert Comment

by:VB ITS
ID: 40478306
Try taking out "| Export-CSV C:\MBSizes.csv" from the end of the command and then see if you get the output you are expecting.
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 24

Expert Comment

by:VB ITS
ID: 40478311
Did you run the above command in the Exchange Management Shell?

You need to replace "Mailbox Database XXXXXXXXXXXXX" with the actual name of the mailbox database on your server as it may not necessarily be named "Mailbox Database Test" (for example).

To get the name of your mailbox database, open the Exchange Management Console on your Exchange server > expand Organization Configuration on the left pane > click Mailbox > in the Database Management tab you should then see the name of your database underneath the Name column.

Let's say your mailbox database name is "2010 MB DB" in this instance. You would then run the command as accordingly:
Get-MailboxStatistics -Database "2010 MB DB" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending

Open in new window


I have found that sometimes you need to replace the speech marks with an apostrophe to get the command to work so give that a shot if you're having issues.
0
 
LVL 19

Assisted Solution

by:Adam Farage
Adam Farage earned 200 total points
ID: 40478418
I would say run the environment report for Exchange, which can be found here: http://www.stevieg.org/2011/06/exchange-environment-report/

Download the script and run it with the following:

.\Get-ExchangeEnvironmentReport -HtmlReport <File Path for HTML Report> -SendMail:$true -MailFrom:ExchangeOps@company.com -MailTo:destinationaddress@company.com -MailServer:HUBTransportServer.company.com

Open in new window


You can also set this up as a scheduled task, which works wonders.
0
 
LVL 23

Author Comment

by:ormerodrutter
ID: 40478423
HI,

I have re-run the Exchange Server Mailbox Statistics Tool after rebooting the server and this time it went through ok. So I got what I wanted but still thank you for your time and effort.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
In this video we show how to create a Contact 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 Recipients >> Contact ta…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

627 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