Solved

How to search Mailboxes for Message Size across a whole Exchange 2003 Server

Posted on 2013-01-04
11
456 Views
Last Modified: 2013-01-16
I am migrating a 1500+ mailbox Exchange 2003 server to 2010.  The 2010 server has a maximum message size of 50 MB, that administration does not want to increase.  I've migrated over 200 mailboxes thus far, with about a 20% failure rate due to oversized messages.

Is there a way to search ALL mailboxes on my Exchange 2003 server for messages over a certain size limit?
0
Comment
Question by:ColdKathleen
  • 6
  • 4
11 Comments
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 38746006
How about using the Exchange message tracker and add the specific criteria to the search interface. It should provide a list of email mesages exceeding your limitation.
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38746343
I guess you want to get the User Mailbox size and what is the current limit of Exchange 2010 DB ?

Get-WmiObject -Namespace "ROOT\MicrosoftExchangeV2" -Class Exchange_Mailbox -filter
`
http://support.microsoft.com/kb/320071

PowerShell - list Exchange 2003 mailbox information
http://www.blkmtn.org/powershell-list-exchange2k3-mb-info

Script - Exchange 2003 Mailbox Size
http://cbfive.com/blog/post/Script-Exchange-2003-Mailbox-Size.aspx

Exchange 2003: Returning mailbox sizes
http://www.indented.co.uk/index.php/2008/10/28/exchange-2003-returning-mailbox-sizes/

http://get-scripting.blogspot.in/2008/07/exchange-2003-wmi-and-powershell-part-1.html
Get-WMIObject -namespace root\MicrosoftExchangeV2 -class Exchange_Mailbox -computer ExchangeServerName | sort-object MailboxDisplayName | format-table MailboxDisplayName,Servername,StorageGroupName,StoreName,Size

- Rancy
0
 

Author Comment

by:ColdKathleen
ID: 38751509
@rancy - I guess you want to get the User Mailbox size and what is the current limit of Exchange 2010 DB ?

Actually, I can find either of these fairly simply.   What I need is to find the maximum message size per mailbox.  Any ideas on that?
0
 

Author Comment

by:ColdKathleen
ID: 38751545
@TG-TIS - How about using the Exchange message tracker and add the specific criteria to the search interface. It should provide a list of email mesages exceeding your limitation.

I don't see an option to add message size in the 2003 Message Tracker, and in the 2010 Message Tracker, I have to specify a mailbox.  (this is really a horrible limitation on the Tracker tool in 2010, IMHO).
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38751582
Maximum message size per mailbox ? Do you mean the Quota or the Message Limit ?

- Rancy
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:ColdKathleen
ID: 38752812
What I'm looking for is a way to find out what the biggest message is in each of my mailboxes.  I am not looking for a limit, I am looking for the largest message in each of the individual mailboxes.  

Alternatively, I would like a list of all messages over 50 MB, or all mailboxes with items > 50 MB.  

I know the 2010 limits, and I know the 2003 limits.  Unfortunately, sometime in the past the 2003 server ran for a couple of years with larger limits than management (my boss) has imposed on the 2010 server.  This means that I'm getting a HUGE number of mailboxes that won't migrate to 2010, without intervention.  

And, no I cannot simply up the number of errors encountered before the migration fails.  There is too much risk that something valuable may be lost.
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38754256
Cool got it you want any email in any folder in user mailbox if above 50MB or something of that sort ..... you will need some VBA or other script to achieve this

- Rancy
0
 

Author Comment

by:ColdKathleen
ID: 38755944
I figured as much, but I can't seem to get PS to cough up the information I'm looking for.
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38762901
Shell doesnt gives you email by email data so thats difficult and only way is through some Scripting that can check mailbox level stuff

- Rancy
0
 

Accepted Solution

by:
ColdKathleen earned 0 total points
ID: 38768125
I found a way to do this through our archive system.  It's clunky, but it works.

Thank you for your thoughts on this on.
0
 

Author Closing Comment

by:ColdKathleen
ID: 38781998
Couldn't find a way without scripting this, and realized that our Archive system can search on message size, so I'm using that instead.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Port v1 4 60
Recommendation of Antivirus software for Personal Use 19 181
Sharepoint to FTP? 3 64
Office 365 and use on Terminal Server - Licenses 2 56
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

863 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

21 Experts available now in Live!

Get 1:1 Help Now