?
Solved

Exchangge Management Shell

Posted on 2014-10-06
18
Medium Priority
?
136 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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Here's a look at newsworthy articles and community happenings during the last month.
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses
Course of the Month11 days, 5 hours left to enroll

770 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