Exchangge Management Shell

How do i generate a report on user mailbox size

how  do i generate a report on folder hierchy
LVL 2
Jorge OcampoAsked:
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.

Joshua GrantomSenior Systems AdministratorCommented:
Run this in an exchange management shell

$users= Get-ADUser -filter * 
foreach ($user in $users) { Get-MailboxStatistics $_. | Select DisplayName,TotalItemSize,ItemCount }
Export-CSV C:\MailboxReport.csv

Open in new window


As for folder hierarchy, are you referring to an individual mailbox?
0
Jorge OcampoAuthor Commented:
there is 10000 mailboxes can it be per user no need to export to csv
0
Joshua GrantomSenior Systems AdministratorCommented:
Get-MailboxStatistics Username | ft DisplayName,TotalItemSize,ItemCount

Open in new window

0
ON-DEMAND: 10 Easy Ways to Lose a Password

Learn about the methods that hackers use to lift real, working credentials from even the most security-savvy employees in this on-demand webinar. We cover the importance of multi-factor authentication and how these solutions can better protect your business!

Joshua GrantomSenior Systems AdministratorCommented:
I was going to suggest Get-MailboxFolderStatistics but I wasn't sure what he meant by folder hierarchy.
0
Jorge OcampoAuthor Commented:
when i run the Get-MailboxStatistics username | Select Name,Foldersize,ItemsinFolder

i doesnt show anything in the name and foldersize and items in folder all empty
0
Joshua GrantomSenior Systems AdministratorCommented:
What are you replacing username with? it should be the login username. Try this one.

Get-MailboxStatistics username | Select DisplayName,Foldersize,ItemsinFolder

Open in new window

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
Jorge OcampoAuthor Commented:
ofcouse but it only shows information under the displayname not under foldersize and itemsinfolder
0
Joshua GrantomSenior Systems AdministratorCommented:
What version of Exchange? and you are running this from the Exchange Management Shell and not just Powershell?
0
Joshua GrantomSenior Systems AdministratorCommented:
It should be FT for Format-Table instead of Select
Get-MailboxStatistics username | FT DisplayName,Foldersize,ItemsinFolder

Open in new window


Select would be used if you wanted to use the export-csv
0
Jorge OcampoAuthor Commented:
2010 using powershell exchange but still it doesnt give any information back i try FT and same problem
0
Joshua GrantomSenior Systems AdministratorCommented:
try to add -identity

Get-MailboxStatistics -identity username | FT DisplayName,Foldersize,ItemsinFolder

Open in new window

0
Jorge OcampoAuthor Commented:
no luck wierd i can see statistics on how many items but cant see when i want to see foldersize
0
Jorge OcampoAuthor Commented:
could it be a permission issue?
0
Joshua GrantomSenior Systems AdministratorCommented:
it could be, What is the highest Admin group you are a member of? Domain, Exchange, Enterprise?
0
Jorge OcampoAuthor Commented:
they are changing my roles, will see after - btw in last post you mention to export mail to mailbox what was the powershell command for exchange 2010

the old mailbox should be a folder in the new one for example inbox>legacy>inbox,etc
0
Jorge OcampoAuthor Commented:
i really appreciate your help
0
Jorge OcampoAuthor Commented:
the answer was use folder statistics with your command
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
Powershell

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.