Brocade Network Advisor IP User Manual 1479
53-1003056-01
Database tables and fields I
TABLE 22 9 MAPS_POLICY
Field Definition Format Size
ID The primary key of the table. int
VIRTUAL_SWITCH_ID The id of the virtual switch. int
NAME The name of the MAPS policy. varchar 32
IS_ACTIVE Indicates if the policy is the active policy on the switch.
0 - No, 1 - Yes.
int
IS_DEFAULT Indicates if the policy is a default policy on the switch. 0
- No, 1 - Yes.
int
TABLE 23 0 MARCHING_ANTS
Field Definition Format Size
ID* Unique generated database identifier. int
THRESHOLD1_VALUE The marching ants low boundary threshold value
(T1).
int
THRESHOLD2_VALUE The marching ants high boundary threshold value
(T2).
int
TABLE 231 MEASURE
Field Definition Format Size
ID Primary key column. int
MEASURE_TYPE Measure type 0 - SNMP MIB, 1-- Expression 2-- EE
Monitor counter 3-- HBA counter,4 - Custom, 5 -
NetworkPatroller, 6 - NOS Ethernet Port optics etc.
smallint
INDEX_TYPE Identifies the index type for a given SNMP MIB or
Expression measure. Various index type supported
are 0 - UNKNOWN, 1 - SCALAR, 2 - IF_INDEX,
3 - ETHER_STATS_INDEX, 4 - CONN_UNIT_INDEX, 5 -
FCIP_LINK_TABLE_INDEX, 6 - CUSTOM, 7 -
SW_TEMP_SENSOR_INDEX, 8 -
SW_FAN_SENSOR_INDEX, 9 -
SW_POWER_SENSOR_INDEX. For non-SNMP
measures like EE Monitors, Ping statistics etc. index
type is not applicable. In that case index type would
be updated as 0 - Unknown.
smallint
NAME Name of the measure. varchar 64
DETAIL For SNMP MIB, stores the OID, for expression, stores
the expression formula.
varchar 1024
UNIT Unit string thats used for displaying the chart. varchar 64
DESCRIPTION Description for the measure. Default: 1 varchar 512
IS_SYSTEM Indicates whether this is a system built in measure,
for system expressions , user cannot delete it.
smallint