Microsoft KB Archive/293887

= How To Analyze Non-Commerce Web Server Log Files =

Article ID: 293887

Article Last Modified on 11/16/2007

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q293887



SUMMARY
This article describes how to analyze log files from a computer that is not running Microsoft Commerce Server 2000 or Commerce Server 2002. The only requirement is that the log files must be in W3C log file format.



MORE INFORMATION
For the purposes of this article, the Web server log files will come from a fictitious Web site and a fictitious Web server. This fictitious server is running Microsoft Internet Information Services (IIS) version 5.0. The URL of this fictitious site is http://noncswebsite.microsoft.com/.

In IIS, the fictitious Web site is named My Custom Web Site. The NetBIOS name of the server is MyNonCS2KSrv, and the IP address of this server is 192.168.5.5. This fictitious Web site logs daily.

To analyze log files, follow these steps:  Install Commerce Server 2000 or Commerce Server 2002 by following the recommended installation instructions for your version of Commerce Server. To view the instructions, visit one of the following Microsoft Web sites:

Commerce Server 2000 Installation Guide

http://support.microsoft.com/default.aspx?scid=/support/commerceserver/2000/install/default.asp

Commerce Server 2002 Installation Guide

http://technet.microsoft.com/en-us/commerceserver/bb608760.aspx

 Unpack the Blank.pup solution site. Select Custom unpack, and then click Next. Select Create a new site, and then click Next. Name the site NonCSAnalysisSite, and then click Next. On the Select Resources screen, click Remove All, and then click Add. Select only Business Desk Permissions, App Default Config, and Data Warehouse. These are the minimum resources that your computer must have for this example. Click Next. On the Global Resource Pointers screen, accept the default. Click Next.</li> Modify the database connection information as appropriate (for example, specify a computer that is running SQL Server and specify a database) on the Database Connection Strings screen, and then click Next.</li> On the Select Applications screen, clear BlankSite, and then click Next.</li> Change the IIS virtual folder of the BlankSiteBizDesk application to NonCSAnalysisBizDesk, and then click Next.</li> On the Data Warehouse screen, change the name of the Data Warehouse to NonCSAnalysis DW, and then click Next. You can also accept the defaults on this screen.</li> After the package is complete, click Finish.</li> Open the Commerce Server Manager Microsoft Management Console (MMC).</li> Under the Commerce Server Manager snap-in, expand Commerce Sites, and then expand the site that you just created (NonCSAnalysisSite).</li> Select Applications, right-click Applications, click New, and then click Add Non-Commerce Application.</li> On the General tab, type the DNS name of the site ( noncswebsite.microsoft.com ) for the Nonsecure host name.</li> Because you want to analyze the whole site, type / for the IIS application path.</li> Click the Web Servers tab. For the IIS Web site, type My Custom Web Site .</li> For Transmission Control Protocol (TCP) and Secure Sockets Layer (SSL) ports, type the correct information based on the configuration of the Web server that the logs are coming from.</li> For the local domain, type microsoft.com, and then click OK.</li> Select the non-commerce application that you just created (noncswebsite.microsoft.com). Right-click noncswebsite.microsoft.com, click New, and then click Add Non-Commerce Web Server.</li> For the server name, type MyNonCS2KSrv, and for the IP address, type 192.168.5.5.

Note You can leave the log file path blank. This is the default path on the Commerce Server Analysis server where the Data Transformation Services (DTS) tasks search for logs. This path must be on the local computer or on a mapped network drive.</li> <li>Select the appropriate log file period based on the configuration of the Web server that the logs are coming from. For the purposes of this article, type Daily. This setting directly affects how the DTS tasks search for log files. Also, the naming convention of the log files is very important. Do not modify the names. Click OK.</li> <li>Open the SQL Enterprise Manager (MMC), expand Microsoft SQL Servers, expand SQL Server Group, and then expand  .</li> <li>Click Data Transformation Services. Right-click Data Transformation Services and then click New Package.</li> <li>From the menu at the top of the window, click Task, and then click Configuration Synchronization (Commerce Server). The Properties dialog box for Synchronize Data Warehouse appears. For the site name, select NonCSAnalysisSite.

Note You must run the Configuration Synchronization task on a newly created data warehouse and after any changes to the Commerce site configuration have been made.</li> <li>From the menu at the top of the window, click Task, and then click Web server log import (Commerce Server). The Properties dialog box for Import Web Server Logs appears.</li> <li>For the site name, select NonCSAnalysisSite.</li> <li>Select the noncswebsite.microsoft.com application.</li> <li>Modify the log file path as required. (This path must be the path of a folder that is located on a local drive or mapped network drive that contains W3C log files.)</li> <li>Click View Log Files. Select all the log files that you want to import. If you do not see any log files, either the log file period is not set correctly or the log file names are not correct.

Note Logs cannot be imported while IIS is actively writing to them.</li> <li>In the Import Web Server Logs task Properties dialog box, click OK.</li> <li>From the menu at the top of the window, click Task, and then click Report Preparation (Commerce Server). The Properties dialog box for Import Web Server Logs appears.</li> <li>For the site name, select NonCSAnalysisSite, and then click OK.</li> <li>Hold down the CONTROL key, and then click Web server log import and Report Preparation. On the Workflow menu, click On Success.</li> <li>To start the DTS task, click the green Play button.</li> <li>After the DTS task is completed, you can start and install the NonCSAnalysisBizDesk. You can use the BizDesk to view the predefined analysis reports.</li></ol>

The following is a list of built-in reports that work when only Web logs are imported:
 * Bandwidth Summary (dynamic)
 * Bandwidth Trends (dynamic)
 * Directories (dynamic)
 * Distinct Users and Visits by Week (dynamic)
 * Distinct Users by Day (dynamic)
 * Entry pages (dynamic)
 * Entry path analysis (static)
 * Exit pages (dynamic)
 * General activity statistics (dynamic)
 * Hits by HTTP status (dynamic)
 * Hits by Win32 status (dynamic)
 * Query strings (multi value) (dynamic)
 * Query strings (single value) (dynamic)
 * Top referring domains by request (static)
 * Top requested pages (static)
 * User trends (dynamic)
 * Usage summary by day of week (dynamic)
 * Usage summary by hour of day (dynamic)
 * Usage summary by week of year (dynamic)
 * Usage trends (dynamic)
 * User visit trends (dynamic)
 * Visits by Browser, Version, and OS (Dynamic)

Note For more information about Commerce Server 2000, see the &quot;Adding a Non-Commerce Application and Web Server&quot; section in the product documentation.

For more information about Commerce Server 2002, visit the following Microsoft Web sites:

Adding a Non-Commerce Web Server to an Application

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csvr2002/htm/cs_mmc_administering_ywnp.asp

Adding a Non-Commerce Application to a Site

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csvr2002/htm/cs_mmc_administering_loju.asp

<div class="references_section">