Solved

Exchangge Management Shell

Posted on 2014-10-06
18
116 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
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
 
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
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
A brief introduction to what I consider to be the best editor for PowerShell.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…

932 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

12 Experts available now in Live!

Get 1:1 Help Now