Supported Log Formats for importing into SmarterStats

Applies to: SmarterStats 4.x

W3C Extended Logs (the default for IIS)

The W3C Extended Log Format includes formatting information into the file, so SmarterStats can handle many variations of the logs. 

More Information:
http://www.w3.org/TR/WD-logfile-960221.html

Required Fields for Proper Importing
http://portal.smartertools.com/KB/a171/which-log-file-fields-are-necessary-to-check-in-iis.aspx

Common Log Format (CLF)

Definition String in Apache

"%h %l %u %t \"%r\" %>s %b"

Fields
clientIP RemoteLoginName Username [d/MMM/yyyy:HH:mm:ss zz00] "Method URL ProtocolAndVersion" ProtocolStatus Bytes 

Example
10.1.1.1 - - [5/Dec/2007:19:00:00 -0500] "GET /Default.htm HTTP/1.1" 200 2857

NCSA extended/combined log format

Definition String in Apache

"%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\""

Fields
ClientIP RemoteLoginName Username [d/MMM/yyyy:HH:mm:ss zz00] "Method URL ProtocolAndVersion" ProtocolStatus Bytes "Referrer" "UserAgent"

Example

10.1.1.1 - - [5/Dec/2007:19:00:00 -0500] "GET /Default.htm HTTP/1.1" 200 2857 "http://www.google.com/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322)"

For more information on Apache configuration, please see: http://httpd.apache.org/docs/1.3/mod/mod_log_config.html

IIS Log Format

For more Information please refer to:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/b344f84e-bc77-4019-859c-9d483bc85c77.mspx?mfr=true

Article ID: 181, Created On: 2/1/2008, Modified: 5/27/2010