asked on 1/7/2013

powershell command

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

Microsoft Legacy OS Microsoft Server OS Exchange

Last Comment

kuzum

1/7/2013

Manpreet SIngh Khatra

1/7/2013

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

kuzum

1/7/2013

ASKER

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

Manpreet SIngh Khatra

1/7/2013

Get-Mailbox -ResultSize Unlimited | Get-MailboxFolderStatistics |Sort-Object SentItems -Descending | Select-Object DisplayName, TotalItemSize, SentItems -First 100

- Rancy

SubSun

1/7/2013

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

kuzum

1/7/2013

ASKER

Subsun

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

ASKER CERTIFIED SOLUTION

SubSun

1/7/2013