SmarterTools Portal Language
 
HomeKnowledge BaseSmarterStatsSupported Log Formats for importing into SmarterStats
Information
Article ID181
Created On2/1/2008
Modified9/12/2008
Share With Others
Supported Log Formats for importing into SmarterStats

Applies to: SmarterStats (all versions)

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
See: http://support.smartertools.com/Customer/KBArticle.aspx?articleid=112

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