Solved

total messages with attachments and average attachment size

Posted on 2004-04-08
8
858 Views
Last Modified: 2012-06-27
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
Comment
Question by:xxgenius
8 Comments
 
LVL 9

Expert Comment

by:robinluo
ID: 10785663
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
 
LVL 8

Author Comment

by:xxgenius
ID: 10785741
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
 
LVL 10

Expert Comment

by:dstoker509
ID: 10785745
With Exchange by itself, this is not possible.
0
 
LVL 8

Author Comment

by:xxgenius
ID: 10785763
dstroker,
thanks. i was hoping there were some perfmon stats that i couldn't find.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 10

Accepted Solution

by:
OneHump earned 500 total points
ID: 10786796
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
 
LVL 8

Author Comment

by:xxgenius
ID: 10790468
thanks OneHump.  my store is actually over 100G on one server and 220G on another.  but your comment is a good answer.
0
 
LVL 8

Author Comment

by:xxgenius
ID: 10790560
OnHump, one last question: do you know how much app analyzer costs? is it per user?
0
 
LVL 10

Expert Comment

by:OneHump
ID: 10792219
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

Want to promote your upcoming event?

Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

Join & Write a Comment

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

746 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

18 Experts available now in Live!

Get 1:1 Help Now