Database Table for Host Header Logging
You must manually create the table in the database
before TMeter records the hosts. A minimal set of the fields for
the table is:
N |
Name |
Type |
Description |
1. |
rtime |
datetime |
Time when this HTTP request was completed. This field must be filled by SQL Server with the current timestamp. |
2. |
filterid |
smallint |
Filter Id |
3. |
rtype |
smallint |
|
4. |
method |
smallint |
|
5. |
reason |
smallint |
|
6. |
clt_ip |
char(16) |
IP address of a client (in decimal-dotted notation, e.g. 192.168.3.250) |
7. |
clt_port |
int |
TCP port number of the client (the range is 0-65535) |
8. |
srv_ip |
char(16) |
IP address of a server (in decimal-dotted notation, e.g. 192.168.3.1) |
9. |
srv_port |
int |
TCP port number of the server (the range is 0-65535) |
10. |
clt_bytes |
int |
Number of bytes transferred from the client to the server |
11. |
srv_bytes |
int |
Number of bytes transferred from the server to the client |
12. |
host |
char(100) |
Host name |
See also: