Solved

Exchangge Management Shell

Posted on 2014-10-06
18
125 Views
Last Modified: 2014-10-07
How do i generate a report on user mailbox size

how  do i generate a report on folder hierchy
0
Comment
Question by:Jorge Ocampo
[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
  • 9
  • 8
18 Comments
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364311
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
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364315
there is 10000 mailboxes can it be per user no need to export to csv
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364316
Get-MailboxStatistics Username | ft DisplayName,TotalItemSize,ItemCount

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364320
I was going to suggest Get-MailboxFolderStatistics but I wasn't sure what he meant by folder hierarchy.
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364339
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
 
LVL 16

Accepted Solution

by:
Joshua Grantom earned 500 total points
ID: 40364345
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
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364351
ofcouse but it only shows information under the displayname not under foldersize and itemsinfolder
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364354
What version of Exchange? and you are running this from the Exchange Management Shell and not just Powershell?
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364359
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
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364364
2010 using powershell exchange but still it doesnt give any information back i try FT and same problem
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364368
try to add -identity

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

Open in new window

0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364396
no luck wierd i can see statistics on how many items but cant see when i want to see foldersize
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364412
could it be a permission issue?
0
 
LVL 16

Expert Comment

by:Joshua Grantom
ID: 40364417
it could be, What is the highest Admin group you are a member of? Domain, Exchange, Enterprise?
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364539
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
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40364540
i really appreciate your help
0
 
LVL 2

Author Closing Comment

by:Jorge Ocampo
ID: 40366467
the answer was use folder statistics with your command
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
A hard and fast method for reducing Active Directory Administrators members.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

729 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