项目作者: peschuster

项目描述 :
Imports w3c log files (iis) into sql server.
高级语言: C#
项目地址: git://github.com/peschuster/LogImporter.git
创建时间: 2012-02-19T17:49:06Z
项目社区:https://github.com/peschuster/LogImporter

开源协议:Other

下载


LogImporter

LogImporter reads webserver log files (iis, w3c), applies transformations on data records and imports them into a database (currently only SQL Server is supported).

Features

  • Parses log files
  • Determines which log entries are new since last import
  • Imports log data into SQL Server
  • Removes guid ids in urls to generate statistics for actual pages (e.g. ASP.NET MVC url routing with guid ids in the path)
  • Resolves client ip address to country name and code (using GeoIP.dat by MaxMind)

Supported formats

  • W3C extended (IIS)

Usage

LogImporter is used from the command line.

The following options are required:

  1. -d=VALUE Directory with log files
  2. -c=VALUE Connection string for target database
  3. -t=VALUE Target table name

Furthermore the following optional parameters are available:

  1. -p=VALUE Pattern for log files
  2. -n Create the table if it does not exist already
  3. -f, --force Force full import of all files

Example usage:

  1. LogImporter.exe -d "D:\logs\W3SVC8" -t w3c_testlog -n -c "Data Source=.\SQLEXPRESS;Initial Catalog=logimporter_test;Integrated Security=True" -p "*.log"

Build

How to build LogImporter:

  1. Go to \build\ directory.
  2. Execute go dist on the command line.

Note: Maybe you have to adjust the path to MSBuild.exe in build\go.bat to your .NET version number.