Thursday, February 5, 2009

How to find 10 Top mailbox users in Exchange 2007

If you are given task to figur out top ten mailbox users in your exchange organization here what you need to do. I have already blog this in the past, and doing it one more time for a request.

  • Log into Exchange server
  • Open EMS (Exchange management shell)
  • Copy paste or type below command in the shell, and hit enter. This command will create CSV file open it and format the csv as you wish.

Get-MailboxStatistics Sort-Object TotalItemSize -Descending select DisplayName,@{expression={$_.TotalItemSize.Value.ToKB()}},ItemCount export-csv MailBoxUsers.csv


Create Custom Address List based on SMTP addresses, the scenario here is you did "contact dump" from another forest and you will need to create custom address list in exchange 2007.

I will post a script soon which can read CSV file and create Contacts in specified OU. This can be useful for one time contact dump (better way is to implement IIFP). After the contact in the OU, you will need to create the address list as below.

  • Change the Custom-AddressList = Name you wish
  • Change @test.smtp25.org to contact you wish to compose this address list.


New-AddressList -Name Custom-AddressList -RecipientFilter {(ExternalEmailAddress -like '*@test.smtp25.org')}


Oz ozugurlu MVP (Exchange)

MCITP (EMA), MCITP (EA) MCITP (SA)

MCSE (M+, S+) MCDST,

Security+, Server +, Project+

Blog: smtp25.blogspot.com

Blog: telnet25.wordpress.com

No comments: