Database Table for Host Header Logging

You must manually create the table in the database before TrafMeter 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

Type of the HTTP request

4.

method

smallint

Method of the HTTP request

5.

reason

smallint

Exit code of the HTTP request

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: