Exchange 2010 user size reportq

I'm trying to get a list of sizes of the size of all users mailboxes on the server. I've spent the last half an our Googleing how to do this and every command I've found just doesn't seem to work. Maybe I'm just messing them all up. it was so much easier in 2003 you could just browse out the storage group and sort the mail boxes by mailbox size. Can anyone tell me  simple way to do this?
LVL 2
Axis52401Security AnalystAsked:
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.

Axis52401Security AnalystAuthor Commented:
I don't know how to use it
0
Nick RhodeIT DirectorCommented:
Exchange Powershell

Get-MailboxStatistics -Database "Mailbox Database Name" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\MBSizes.csv
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.

AmitIT ArchitectCommented:
check second link it has video also, how to use it
0
Axis52401Security AnalystAuthor Commented:
NRhode

That command doesn't seem to do anything
0
Axis52401Security AnalystAuthor Commented:
I watched the video, it shows how to run one command to get the stattistics for one user, I'm looking for a way of getting list of all users
0
Nick RhodeIT DirectorCommented:
doesnt do anything?  What error message are you recieving?  Also you have to input your own mailbox database name.

On the exchange server or if you the exchange management tools installed on your workstation.  You input this command using exchange powershell
0
Mahesh SharmaCommented:
Try this:

Get-MailboxStatistics -ResultSize Unlimited | Sort-Object TotalItemSize -descending | Select DisplayName, ItemCount, TotalItemSize, Database, StorageLimitStatus  | Export-Csv Export.csv
0
Axis52401Security AnalystAuthor Commented:
This one seemes to work on one of my servers, it didn't save the text file but it displayed the list and at least gave me the info I needed

Get-MailboxStatistics -Server exchange |
Sort-Object -Property TotalItemSize |
Format-Table DisplayName,TotalItemSize >c:\email.txt
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
Axis52401Security AnalystAuthor Commented:
this one seemed to give the correct data
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.