Get mailbox size on Exchange 2010

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.
LVL 23
ormerodrutterAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

VB ITSSpecialist ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ormerodrutterAuthor Commented:
No that didn't. I have searched the entire C:\ drive and nothing.
0
VB ITSSpecialist ConsultantCommented:
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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

VB ITSSpecialist ConsultantCommented:
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
Adam FarageEnterprise ArchCommented:
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
ormerodrutterAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.