Solved

Get mailbox size on Exchange 2010

Posted on 2014-12-03
6
210 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
  • 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
Problems using Powershell and Active Directory?

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

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In-place Upgrading Dirsync to Azure AD Connect
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…

840 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