IISODBC Input Format Fields
The input records generated by the IISODBC input format contain the following fields:
| Name | Type | Description |
|---|---|---|
| ClientHost | STRING | The IP address of the client that made the request |
| Username | STRING | The name of the authenticated user that made the request, or NULL if the request was from an anonymous user |
| LogTime | TIMESTAMP | The date and time at which the request was served (local time) |
| Service | INTEGER | The IIS service name and site instance number that served the request |
| Machine | STRING | The name of the server that served the request |
| ServerIP | STRING | The IP address of the server that served the request |
| ProcessingTime | INTEGER | The number of milliseconds elapsed since the moment the server received the request to the moment the server sent the last response chunk to the client |
| BytesRecvd | INTEGER | The number of bytes in the request sent by the client |
| BytesSent | INTEGER | The number of bytes in the response sent by the server |
| ServiceStatus | INTEGER | The response HTTP or FTP status code |
| Win32Status | INTEGER | The Windows status code associated with the response HTTP or FTP status code |
| Operation | STRING | The HTTP request verb or FTP operation |
| Target | STRING | The HTTP request uri-stem or FTP operation target |
| Parameters | STRING | The HTTP request uri-query, or NULL if the requested URI did not include a uri-query |