user manual

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:
■ 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.
Table 19 lookup_2
lookup_2
NL Type DNS Layer 1 Country
IP Fr France
IP Uk U.K.
IP De Germany
IP * <unknown>
* * <?>