Solved

powershell command

Posted on 2013-01-07
8
888 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
  • 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Question has a verified solution.

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

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now