Solved

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

Posted on 2008-09-29
7
337 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

This article explains how to install and use the NTBackup utility that comes with Windows Server.
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
In this video we show how to create an Address List 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 Organization >> Ad…
how to add IIS SMTP to handle application/Scanner relays into office 365.

751 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