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+



Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: