Using the dblookup Program 143

network-type lookup tables: for example, a database containing only IP_1 and other_2 lookup-tables is valid.

For specific information about Access or Excel lookup-tables, see below.

Default Values Devices may be assigned default values. If no full match was found for the current device, dblookup looks for default entries defined with star (’*’) as the key attribute values, and assigns the new attributes with the values of the best match (the one with as few stars as possible).

If no match is found for the current device, dblookup does not set any attribute, but waits for a new device to be looked-up.

Table 19 shows an example of this:

Table 19

lookup_2

 

 

 

 

lookup_2

 

 

 

 

 

NL Type

DNS Layer 1

Country

IP

Fr

France

IP

Uk

U.K.

IP

De

Germany

IP

*

<unknown>

*

*

<?>

 

 

 

lookup_2 is a general lookup table based on 2 attributes: NL Layer Type and DNS Layer 1. This lookup table sets the value for the Country attribute.

An IP device called ’www.demon.co.uk’ gets the ’U.K.’ Country attribute;

An IP device called ’www.yahoo.com’ gets the ’<unknown>’ Country attribute;

An IPX device gets the ’<?>’ Country attribute.

Access Database The lookup-tables should be either standard Access tables or queries; the column names must match Traffix Manager attribute names. You can improve performance by defining indexes on the key columns.

Page 143
Image 143
HP Transcend Traffix Manager manual Lookup2