• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 870
  • Last Modified:

total messages with attachments and average attachment size

does anyone know a why to get data on exchange server 2000 (or 2003) for the number of messages in the mail store that contain attachments.  also if it is possible, is there a way to show the average attachment size or total size of attachments?
this will need to be without 3rd party tools.
0
xxgenius
Asked:
xxgenius
1 Solution
 
robinluoCommented:
you may want to do it this way:

- create a new folder.
- copy all the messages you want to estimate into this folder

from the status bar, you know how many emails are in this folder

- right click on this folder and select properties
- click on "folder size" button in General tab

now you know the total size.

and you can then estimate the average size of each message.
0
 
xxgeniusAuthor Commented:
robinluo, this is for the exchange server, not outlook.  i need the total number of messages taht have attachments and the average size of each attachment.
0
 
dstoker509Commented:
With Exchange by itself, this is not possible.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
xxgeniusAuthor Commented:
dstroker,
thanks. i was hoping there were some perfmon stats that i couldn't find.
0
 
OneHumpCommented:
Use exmerge to search for all attachments and export those messages.  You should find that the size of the export footprint is double the real size of the data stored in the .pst.  I would confirm this by opening a .pst and taking a sample.  Get the ration of real size to .pst size.  Then, sum up the size of the export directory, multiply it by the ratio you came up with and then mutiply it by your single instance storage ratio to get a pretty close estimation of what you are looking for.

Personally, I would use something like app analyzer, but that's pretty much the only non-programmatic way to get what you want.  If you have a small store it's not a problem.  If you have 40G, you may want to reconsider.

OneHump
0
 
xxgeniusAuthor Commented:
thanks OneHump.  my store is actually over 100G on one server and 220G on another.  but your comment is a good answer.
0
 
xxgeniusAuthor Commented:
OnHump, one last question: do you know how much app analyzer costs? is it per user?
0
 
OneHumpCommented:
No problem.  You're not going to want to run exmerge on a store that big.  As a matter of fact, I'd like to suggest that you get that store down below 40G or so.  You can't imagine the frustration you'll face having to recover a store/storage group that large.  It could take you well over a week if you don't have a clean backup.  

It's pretty expensive, but I can't answer that because they are flexible with their pricing. Retail is always different from the actual price.  Our price was $200,000 for 50,000 seats/175 servers.  I don't know if the license was per server or per seat.  My guess is per server.  I would get with NetIQ and ask for a quote.

OneHump
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now