asked on

Number of External emails sent from User Micrsoft exchange 2003

Hi Is there a way to easily count the number of emails sent to external email address, I know you can go into Exchange System Manager then use "Message Tracking Center" but this is a manual way. Ie it would be good to have a program like Message Tracking Center which has a filter where you can put Exclude: *.<domain>.local and it will show all emails sent from that user to external email. Then at the bottom have a total of emails.

In Sort I am looking for an Advanced Message Tracking Center

Thanks
Dennis

Julian123

The best way to do this would be to turn on the message tracking feature, which creates comma separated files with entries for each message sent. These can be loaded into excel or parsed with a custom script you could write to determine which e-mails were outbound. Note that there are often multipe message tracking logs files so they would all needed to be loaded into excel or parsed by the script I mentioned.

This article talks more about turning on message tracking: http://www.msexchange.org/tutorials/Exchange-2003-Message-Tracking-Logging.html

DennisLBM

ASKER

Yep "Message Tracking" is turned on and has been for ages. So what would the steps be to count the number of email "Joe" has sent external in the last two weeks?

(attached is a list of the log files)

Thanks
Dennis
Message-Tracking-Logs.JPG

Julian123

These can be loaded into excel one at a time and you could then use Excel filtering to show only entires sent by Joe. Obviously, thsi would require manual effort so it's easiest to combine all the files into one big one (http://melaniedejonge.com/merge-files-and-combine-files-a-quick-way-to-combine-or-merge-csv-files OR http://www.computing.net/answers/programming/merge-combine-append-all-csv-files/19890.html).

Another option would be to write a script (VB, powershell, etc.) that would open each file and determine which e-mails were outbound by Joe.

ASKER CERTIFIED SOLUTION

Mestha

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DennisLBM

ASKER

Thanks I found another program similar to the programs listed on http://www.amset.info/exchange/message-tracking.asp but it was only a 30day trial called WebSpy Vantage. Wish there was a free version which has reporting functions and simple\easy to use.

DennisLBM

ASKER

Just wish there was a free version of the software limited day trial but it worked and allowed me to get the reports i needed