Using the dblookup Program 143network-type lookup tables: for example, a database containing only IP_1and 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 forthe current device, dblookup looks for default entries defined with star(’*’) as the key attribute values, and assigns the new attributes with thevalues 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 anyattribute, but waits for a new device to be looked-up.Table 19 shows an example of this:n lookup_2 is a general lookup table based on 2 attributes: NL LayerType and DNS Layer 1. This lookup table sets the value for the Countryattribute.n An IP device called ’www.demon.co.uk’ gets the ’U.K.’ Countryattribute;n An IP device called ’www.yahoo.com’ gets the ’’ Countryattribute;n An IPX device gets the ’’ Country attribute.Access Database The lookup-tables should be either standard Access tables or queries; thecolumn names must match Traffix Manager attribute names. You canimprove performance by defining indexes on the key columns.Table 19 lookup_2lookup_2NL Type DNS Layer 1 CountryIP Fr FranceIP Uk U.K.IP De GermanyIP * * *
