Solved

Exchangge Management Shell

Posted on 2014-10-06
18
118 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
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…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

777 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