Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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

How do I check mailbox store sizes for our users with Exchange 2007?  Thanks.
0
LB1234
Asked:
LB1234
  • 3
  • 3
1 Solution
 
dathhoCommented:
get-mailboxstatistics | fl displayname,totalitemsize
0
 
LB1234Author Commented:
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
 
gupnitCommented:
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
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

 
dathhoCommented:
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
 
LB1234Author Commented:
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
 
dathhoCommented:
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
 
LB1234Author Commented:
That worked, thanks :)
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now