Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1633)

Brocade Network Advisor SAN User Manual 1581
53-1003154-01
Database tables and fields
H
TABLE 134 FABRIC_DISCOVERY_POLICY_RULE
Field Definition Format Size
ID serial
FABRIC_ID The database ID of the fabric that the policy belongs
to. int
FILTER Filter to be applied for this fabric. This could be IP
Address or WWN or SwitchType. The Type of the filter
comes from the FilterType column. This can be either
in included list or excluded list depending on the
EXCLUDED column value. varchar 128
FILTER_TYPE This column indicates type of the filter. It could take
values like 0 for IP Address, 1 for WWN and 2 for
SwitchType. Default is IP address type. smallint
EXCLUDED This column indicates if the Filter in the record
should be included or excluded. 1 means exclude
and 0 means include. Default is to include. smallint
CREATION_TIME timestamp
LAST_UPDATE_TIME timestamp
TABLE 135 FABRIC_MEMBER
Field Definition Format Size
FABRIC_ID* Fabric ID, foreign key to FABRIC table. int
VIRTUAL_SWITCH_ID* ID of the virtual switch which is a member of this fabric,
foreign key to VIRTUAL_SWITCH table. int
TRUSTED 1 = the switch is a trusted member of the fabric. Either
found in the initial discovery or user subsequently
entrusted the switch by user action.
Default Value is 0. smallint
CREATION_TIME When the switch became a member.
Default Value is ’now()’. timestamp
MISSING 1 = it is missing from the fabric.
Default Value is 0. smallint
MISSING_TIME When it is missed from the fabric; null if the member is
entrusted. timestamp
LAST_UPDATE Last Updated time for the record. bigint
TABLE 136 FABRIC_THRESHOLD_SETTING
Field Definition Format Size
FABRIC_ID* References the ID in FABRIC table int
POLICY_ID* References the ID in THRESHOLD_POLICY table int