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