Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1111
53-1002167-01
Database tables and fields
E
DESCRIPTION Description of the rule varchar
SCOPE Scope of the rule - is it applicable to Fabric, switch or
ports
varchar
CATEGORY Category of the rule - is it used by unknown - 0, asset
collection - 1, or 2 - the license manager service
smallint
ENABLE Whether the rule needs to be considered or not. 1 -
consider, 0 - do not consider for calculation.
The default value is 1.
smallint
TABLE 332 LOCK
Field Definition Format Size
NAME The name of this transaction synchronization lock. The
name should be upper case and should describe the
activity being synchronized, such as
MANAGED_ELEMENT_CREATION.
varchar 40
LAST_USED_BY Identifies the transaction that last updated this lock
record, such as IP_DISCOVERY. This field is primarily
here just to have something to modify. The new value
does not need to be different than the previous value.
varchar 40
LAST_USED_TIME Optional time when the lock was last modified. Might
be useful for debugging someday.
timestamp
TABLE 333 MANAGED_ELEMENT
Field Definition Format Size
ID An ID that is unique across managed elements of all
types: SAN physical switches, SAN logical switches, IP
switches, and hosts. Also the primary key for the
MANAGED_ELEMENT table.
int
PLACEHOLDER Not used. iBatis/Abator requires at least one non-serial
column to generate correct objects. The default value is
0.
int
TABLE 334 NPORT_WWN_MAP
Field Definition Format Size
ID int
VIRTUAL_SWITCH_ID AG switch reference on which the Nport wwn mapping
resides.
int
N_PORT N Port through which AG is connected to the edge
switch
smallint
DEVICE_PORT_WWN Device Port which is mapped to the N port. This device
could be offline device as well.
char 23
TABLE 331 LICENSE_RULE (Continued)
Field Definition Format Size