Solved

powershell command

Posted on 2013-01-07
8
892 Views
Last Modified: 2013-01-07
Hi,

I need a power shell command to list largest top 100 mailbox that has largest "sent items"  folder size sorted by mailbox name,

we have exchange 2010 environment

thanks everyone
Kuzum
0
Comment
Question by:kuzum
[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
  • 3
  • 3
  • 2
8 Comments
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38751933
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName, TotalItemSize -First 100

http://myitforum.com/cs2/blogs/yli628/archive/2008/05/06/powershell-script-to-list-the-top-10-mailbox-user-on-your-exchange-2007-server.aspx

- Rancy
0
 

Author Comment

by:kuzum
ID: 38751953
thanks Rancy, this will show size of the mailbox but I need only the "sen items" folder size. Can you amend this to give the result I need please

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName, TotalItemSize -First 100
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38751976
Get-Mailbox -ResultSize Unlimited | Get-MailboxFolderStatistics |Sort-Object SentItems -Descending | Select-Object DisplayName, TotalItemSize, SentItems -First 100

- Rancy
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 40

Expert Comment

by:Subsun
ID: 38751982
Try..
Get-Mailbox -ResultSize Unlimited | Get-MailboxFolderStatistics -FolderScope 'SentItems' | Sort-Object FolderSize -Descending | Select-Object -First 100 Identity, FolderPath, ItemsInFolder, FolderSize

Open in new window

0
 

Author Comment

by:kuzum
ID: 38752172
Subsun

this is great, Can I export this to a excel file?
0
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 38752181
Yes..
Get-Mailbox -ResultSize Unlimited | Get-MailboxFolderStatistics -FolderScope 'SentItems' | Sort-Object FolderSize -Descending | Select-Object -First 100 Identity, FolderPath, ItemsInFolder, FolderSize | Export-csv c:\report.csv -NoTypeInformation

Open in new window

0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38752194
Good to see my initial command reworked couldnt have asked better :)

- Rancy
0
 

Author Closing Comment

by:kuzum
ID: 38752394
Great solution
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
To show how to generate a certificate request 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 >> Certificates…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

691 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