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

1 comment:

advmovers said...

Best Moving Company +971 50 3605353
Office and staff relocation should run as professionally and cost efficiently as any successful business. Therefore ADV MOVERS Corporate aim to provide you with the best moving services and moves without any comebacks.

Movers in Dubai
office movers in dubai
Affordable Moving Company in Dubai
Packer in Dubai
Re locate services in Dubai
Professional Movers in Dubai
Movers and Packers Abu Dhabi


http://www.advmovers.com/