Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-09-29
7
Medium Priority
?
348 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
[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
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 2000 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

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

715 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