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

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?
ColdKathleenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony GiangrecoCommented:
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
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
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
ColdKathleenAuthor Commented:
@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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

ColdKathleenAuthor Commented:
@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
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Maximum message size per mailbox ? Do you mean the Quota or the Message Limit ?

- Rancy
0
ColdKathleenAuthor Commented:
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
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
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
ColdKathleenAuthor Commented:
I figured as much, but I can't seem to get PS to cough up the information I'm looking for.
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
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
ColdKathleenAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ColdKathleenAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.