Solved

How do I check mailbox store sizes for our users with Exchange 2007?

Posted on 2008-09-29
7
315 Views
Last Modified: 2012-05-05
How do I check mailbox store sizes for our users with Exchange 2007?  Thanks.
0
Comment
Question by:LB1234
  • 3
  • 3
7 Comments
 
LVL 6

Expert Comment

by:dathho
ID: 22596595
get-mailboxstatistics | fl displayname,totalitemsize
0
 
LVL 1

Author Comment

by:LB1234
ID: 22596661
ugh, is there anyway to output this to an excel document or .csv or better organize it, or sort it by size or something?  This is horrendous compared to the at-a-glance listing in exchange 2003.
0
 
LVL 32

Expert Comment

by:gupnit
ID: 22596839
Hi,
One of these should work....couldn't test as not in front of server
get-mailboxstatistics | fl displayname,totalitemsize | export-csv -path mailsize.csv
get-mailboxstatistics | export-csv -path mailsize.csv
Thanks
Nitin
0
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.

 
LVL 6

Expert Comment

by:dathho
ID: 22596884
OK, a little fancier then.
Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount | Export-csv c:\filename.csv

This script will list all mailboxes starting with the largest then Descending down the page it will also give you number of items in each mailbox and list size in MB.

Play around a bit with the paramaters to get what you need.
0
 
LVL 1

Author Comment

by:LB1234
ID: 22623096
none of these strings are working, i mean stuff is exported to the files, but it's all basically garbage (long strings of random characters), not usable numbers.
0
 
LVL 6

Accepted Solution

by:
dathho earned 500 total points
ID: 22624935
try this.  replace the format-list(fl) or format-table(ft) cmdlet with select-object

get-mailboxstatistics | select-object displayname,totalitemsize  | Export-Csv  mailsize.csv
0
 
LVL 1

Author Closing Comment

by:LB1234
ID: 31501186
That worked, thanks :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exchange 2010 fails to send outgoing email 7 60
exchange 2013 4 43
Additional Mailboxes in Microsoft Outlook 2 38
Exchange 2010 - Best practice MDB Data size 8 58
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Find out what you should include to make the best professional email signature for your organization.
In this video we show how to create an Accepted Domain 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 Mail Flow >> Ac…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now