Solved

Need to find the Average email size in Exchange 2007

Posted on 2013-11-19
4
399 Views
Last Modified: 2013-11-19
How do i find it from Exchange 2007, dont use any third party.

Average email size
Number of inbound mail (internal & external) per day
Number of outbound mail (internal  & external) per day

I would appreciate, if you give powershell command. Thanks
0
Comment
Question by:Vijaya Babu Sekar
4 Comments
 
LVL 3

Assisted Solution

by:Exchange_Imran
Exchange_Imran earned 150 total points
ID: 39658763
0
 
LVL 1

Expert Comment

by:zaicnupagadi
ID: 39658998
hi vijayhakcer,

I don't have PS console in front of me now, but I guess you can use the cmdlet like for ex.:

Get-MessageTrackingLog -Start "11/19/2013 11:59PM" -End "11/20/2013 11:59PM" and after that you can pipe with " | select TOTALBYTES" and pipe this with "| measure-object " to get the sum, for ex.:

$all_mess = (Get-MessageTrackingLog -Start "11/19/2013 11:59PM" -End "11/20/2013 11:59PM" | measure-object)
$all_mess.sum()

About the inbound/outbound you can have by selecting the proper messages with pipe and "| where { -EventID -match "SEND" }" for mails send or "RECEIVED" - using the command from abovem and then you take ".count()" from that for ex.:

$send = (Get-MessageTrackingLog -Start "11/19/2013 11:59PM" End "11/20/20131:59PM"  | ? {_EventID -match "SEND"})
$send.count()

Then you divide :) I would love to help more but as long I am not in the fornt of the console... ;/ sorry mate. Hope helped at least a little bit.
0
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 350 total points
ID: 39659047
I would recommend four ways of doing so:

1. Exchange Server Profile Analyzer tool:  Will analyze all logs, etc. and will provide average mailbox size.  This is a free download from MS at http://www.microsoft.com/en-us/download/details.aspx?id=10559
2. Log Parser Studio:  This utility can analyze all logs (IIS, SMTP, Exchange, etc.) and can provide granular results.  You can get a copy free from MS at  http://gallery.technet.microsoft.com/Log-Parser-Studio-cd458765
3.  Get the script listed below from MS by going to http://gallery.technet.microsoft.com/scriptcenter/bb94b422-eb9e-4c53-a454-f7da6ddfb5d6
4. I used to use the script in option 3 above but then I started using Splunk (http://www.splunk.com)
0
 
LVL 10

Author Closing Comment

by:Vijaya Babu Sekar
ID: 39661422
Yes, I referred Exchange Profile Analyzer and log parser.  Thanks
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…

919 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

16 Experts available now in Live!

Get 1:1 Help Now