Topic Last Modified: 2007-05-16
The following list describes open database connectivity (ODBC) logging:
- You must set up an ODBC-compliant database before you use this
format.
- Information is written to a database.
- There are multiple records for a single transmission.
The following table describes the fields and data types for an ODBC transaction log file.
Field name | Data type | Description |
---|---|---|
ClientHost |
varchar(255) |
Client IP address |
Username |
varchar(255) |
Client domain name |
LogTime |
datetime |
Connection date and time |
Service |
varchar(255) |
Internet Information Services (IIS) service |
Machine |
varchar(255) |
Computer name |
ServerIP |
varchar(50) |
Server IP address |
ProcessingTime |
integer |
Processing time in milliseconds |
BytesRecvd |
integer |
Bytes received by server |
BytesSent |
integer |
Bytes sent by server |
ServiceStatus |
integer |
Simple Mail Transfer Protocol (SMTP) protocol reply code |
Win32Status |
integer |
Windows Server 2008 status or error code (A value of 0 indicates success.) |
Operation |
varchar(255) |
SMTP protocol command |
Target |
varchar(255) |
Recipient |
Parameters |
varchar(255) |
No description available |