MsExchange Blog Spot Telnet25

February 5, 2009

How to find 10 Top mailbox users in Exchange 2007

Filed under: General (1) — telnet25 @ 8:57 pm

If you are given task to figure out, the 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.

  • 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 to contact you wish to compose this address list.


New-AddressList -Name Custom-AddressList -RecipientFilter {(ExternalEmailAddress -like ‘*’)}


Oz ozugurlu MVP (Exchange)



Security+, Server +, Project+




Blog at