|
The Database Table for storing Filter Names
When you enable logging into database,
it will be useful to easy find the Filter Name by its Filter Id
because the Filter Name is not stored in database
along with traffic counters, packets or HTTP hosts headers.
This table allows to simplify building SQL statements
from several tables.
Table for storing Filter Names should have name
"filters" and the following format:
N |
Column name |
Type |
Description |
1. |
filterid |
smallint |
Filter Id, integer value (1 - 32768) |
2. |
filtername |
char(120) |
Filter Name |
Filling this table occurs every time
when traffic capture starts and if you enable at least
one type of logging into database (traffic counters,
packets or Host headers HTTP). To create this table
in Microsoft SQL Server, you can use the following command:
CREATE TABLE [dbo].[filters] (
filterid int PRIMARY KEY,
filtername char(120) NOT NULL)
|
 Note
- Table "Filters" is not mandatory table. TrafMeter will work
normally, if this table doesn't exist.
|
