Compiling Exchange Server SMTP statistics in W3C Extended Log File Format using the technique described in the SearchExchange.com tip, Enabling protocol logging for Exchange Server, works -- but sometimes the end result can be challenging to read.
[IMAGE]
Figure A: An SMTP log looks in W3C Extended Log File Format.
Each line of the W3C Extended Log File Format file represents a separate log entry. The first half of each line follows a basic column format, but the second half of the log file entry defies any sort of structure.
Fortunately, there is an alternative. Exchange Server SMTP log files become much more legible if you import them into Microsoft Excel. An added benefit to this approach is that you can analyze your Exchange Server SMTP traffic patterns using basic Microsoft Excel functionality.
In this step-by-step guide, Exchange MVP Brien Posey explains how to convert an Exchange Server SMTP lo
To continue reading for free, register below or login
To read more you must become a member of SearchExchange.com
g file into a text file and import it into Microsoft Excel. He then walks through two approaches for evaluating those log files to determine your Exchange Server's SMTP bandwidth consumption.
If you have any comments or questions about the information presented herein, please send an email to editor@searchexchange.com.
[IMAGE]
[IMAGE]STEP-BY-STEP GUIDE: HOW TO ANALYZE SMTP LOG FILES IN EXCEL
[IMAGE]
[IMAGE] Home: Introduction
[IMAGE] Step 1: Convert the Exchange Server SMTP log file to a text file
[IMAGE] Step 2: Import the Exchange Server SMTP log file into Excel
[IMAGE] Step 3: Analyze SMTP traffic bandwidth consumption in Excel
[IMAGE] Step 4: Related resources from SearchExchange.com
[TABLE]
