Number of External emails sent from User Micrsoft exchange 2003

DennisLBM
DennisLBM used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

Commented:
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
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Expert of the Quarter 2009
Expert of the Year 2009
Commented:
If you have the skills in Access, then PromoDag have a tool that can import the logs and then you can create reports.
If it is a one off thing, then download one of the Message Tracking processing tools to process them. There are lots of those around - I have a list on my web site: http://www.amset.info/exchange/message-tracking.asp

Simon.

Author

Commented:
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.

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial