How to Configure the Default Web Site Properties for Import
Before you can import Web log files into the Data Warehouse, you must configure the Web log file properties to use the World Wide Web Consortium (W3C) log file format. You configure the Web log file properties by using Internet Information Services (IIS) Manager.
To configure the default Web site properties for import
Click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
In the IIS Manager console, in the left pane, expand Internet Information Services, expand the server on which you unpacked the site, right-click the default Web site, and then click Properties.
In the Default Web Site Properties dialog box, on the Web Site tab, in the Enable logging section, do the following:
Use this
To do this
Enable Logging
Select this check box if you want to enable the log to record Web site activity.
Active log format
Select W3C Extended Log File Format from the drop-down list.
Click Properties.
In the Logging Properties dialog box, on the Advanced tab, do the following:
Use this
To import this
Date
The date on which activity occurred on the Web site.
Time
The time the activity occurred.
Client IP Address
The IP address of the client that accessed the server.
User Name
The name of the user who accessed the server.
Service Name
The Internet service and instance number that was accessed by a client.
Server Name
The name of the server on which the log entry was generated.
Server IP Address
The IP address of the server on which the log entry was generated.
Server Port
The port number the client is connected to.
Method
The action the client was trying to perform, for example, open a Web page.
URI Stem
The Uniform Resource Identifier (URI) stem of the resource accessed, for example, an HTML page.
URI Query
The query, if any, that the client was trying to perform. For example, a search string for which a client was seeking a match.
Protocol Status
The status of the action, in HTTP or FTP terms.
Protocol Substatus
The additional status of the action, in HTTP or FTP terms.
Win32 Status
The status of the action, in terms used by Microsoft Windows.
Bytes Sent
The number of bytes sent by the server.
Bytes Received
The number of bytes received by the server.
Time Taken
The length of time (in milliseconds) the action took to finish.
Protocol Version
The protocol (HTTP, FTP) version used by the client. For HTTP, this is either HTTP 1.0 or HTTP 1.1.
Host
The content of the host header.
User Agent
The browser used on the client.
Cookie
The content of the cookie sent or received.
Referrer
The site that directed the user to the current site.
You must select Client IP address, URI stem, and Time for Web log files to be imported correctly. Include the Date property to ensure accuracy in the reporting of dates. For information about how to set Web server properties, see How to Configure a Web Server.
Do not select Use local time for file naming and rollover. The Data Warehouse requires that the log file names are in Coordinated Universal Time, or Greenwich Mean Time (GMT). Setting this option could cause some log files not to be imported.
In the Logging Properties dialog box, click OK.
In the Default Web Site Properties dialog box, click OK.