?
Solved

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

Posted on 2013-01-04
11
Medium Priority
?
464 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 

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
 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

621 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