Avatar of kuzum
kuzum

asked on 

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 OSMicrosoft Server OSExchange

Avatar of undefined
Last Comment
kuzum
Avatar of Manpreet SIngh Khatra
Manpreet SIngh Khatra
Flag of India image

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
Avatar of kuzum
kuzum

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
Get-Mailbox -ResultSize Unlimited | Get-MailboxFolderStatistics |Sort-Object SentItems -Descending | Select-Object DisplayName, TotalItemSize, SentItems -First 100

- Rancy
Avatar of SubSun
SubSun
Flag of India image

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

Avatar of kuzum
kuzum

ASKER

Subsun

this is great, Can I export this to a excel file?
ASKER CERTIFIED SOLUTION
Avatar of SubSun
SubSun
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Good to see my initial command reworked couldnt have asked better :)

- Rancy
Avatar of kuzum
kuzum

ASKER

Great solution
Exchange
Exchange

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

213K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo