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