Microsoft IIS ODBC Log Format
ODBC logging format is a record of a fixed set of data fields in an ODBC-compliant database, such as Microsoft Access or Microsoft SQL Server.
Some of the items logged are:
The user's IP address
User name
Request date and time
HTTP status code
Bytes received
Bytes sent
Action carried out (for example, a download carried out by a GET command)
The target (for example, the file that was downloaded).
The time is recorded as local time
You must specify the database to be logged to.
You must setup the database table manually to receive the data.
To use ODBC logging, you must complete the following steps:
Create a database containing a table with the appropriate fields for the logging data.
IIS includes a SQL template file which can be run in a SQL database to create a table that accepts log entries from IIS.
The file is called Logtemp.sql and is available in the following location by default:
c:\winnt\system32\inetsrv\logtemp.sql
The following fields are required and in this format
Field Name |
SQL Server Field Type |
MS Access Field Type |
| ClientHost |
varchar(255) |
text (255) |
| Username |
varchar(255) |
text (255) |
| LogTime |
datetime |
datetime |
| Service |
varchar(255) |
text (255) |
| Machine |
varchar(255) |
text (255) |
| ServerIP |
varchar(50) |
text (50) |
| ProcessingTime |
int |
int |
| BytesRecvd |
int |
int |
| BytesSent |
int |
int |
| ServiceStatus |
int |
int |
| Win32Status |
int |
int |
| Operation |
varchar(255) |
text (255) |
| Target |
varchar(255) |
text (255) |
| Parameters |
varchar(255) |
text (255) |
Create an ODBC Data Source Name (DSN), which is a name that the ODBC software uses to find the database.
Supply IIS with the name of the database and table. If a user name and password are needed for accessing the database, you must also specify these in IIS.
Nihuo Web Log Analyzer supports Microsoft IIS ODBC Log Format-- it can process log files in Microsoft IIS ODBC Log Format, and generate dynamic statistics from them, analyzing and reporting server traffic. Please give try, you will find the best IIS log analyzer and the best Apache log file analyzer in the world.
Nihuo Web Log Analyzer also supports other log formats; See the list containing Microsoft IIS ODBC Log Format and all other supported formats.
