Solved

Exchangge Management Shell

Posted on 2014-10-06
18
114 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
  • 9
  • 8
18 Comments
 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
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
Comment Utility
there is 10000 mailboxes can it be per user no need to export to csv
0
 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
Get-MailboxStatistics Username | ft DisplayName,TotalItemSize,ItemCount

Open in new window

0
 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
ofcouse but it only shows information under the displayname not under foldersize and itemsinfolder
0
 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
What version of Exchange? and you are running this from the Exchange Management Shell and not just Powershell?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
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
Comment Utility
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
Comment Utility
try to add -identity

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

Open in new window

0
 
LVL 2

Author Comment

by:Jorge Ocampo
Comment Utility
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
Comment Utility
could it be a permission issue?
0
 
LVL 16

Expert Comment

by:Joshua Grantom
Comment Utility
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
Comment Utility
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
Comment Utility
i really appreciate your help
0
 
LVL 2

Author Closing Comment

by:Jorge Ocampo
Comment Utility
the answer was use folder statistics with your command
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

763 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now