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) | 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 | SMTP protocol reply code |
| Win32Status | integer | Windows 2000 Server status or error code (a 0 value indicates success) |
| Operation | varchar(255) | SMTP protocol command |
| Target | varchar(255) | Recipient |
| Parameters | varchar(255) |