Supported Log Formats for importing into SmarterStats

Applies to SmarterStats 6.x - 11.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:
SmarterTools Knowledge Base - Determine Which Log Files are Necessary to Check in IIS

Common Log Format (CLF)

The Common Log Format is an Apache logging format that includes most basic information about traffic to a website. Due to missing referral and user agent information, however, some reports in SmarterStats may show up empty if you use this format. If possible, it is recommended to use NCSA Extended or W3C Extended logs.

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

 

Learn more about how SmarterStats can help you better understand your website analytics.

Feedback

Add Feedback
What about Amazon S3 and CloudFront Logs. We have .Net classes for the conversion if you need them.

We currently first have to convert these logs. :(

Thanks,

Markus (long term customer)

Markus Schneider (June 16, 2015 at 1:01 AM)
Hi Markus, If S3 and CloudFront logs are not importing then they are not following the above format that is supported. I would suggest to post this in the community section as a feature request.
Brian Ward (June 16, 2015 at 9:07 AM)

Add Feedback