Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1252 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
VIOLATION_TYPE The type of the violation. i.e. CRC, ITW. int
MANAGED_ELEMENT_ID The managed element corresponding to this event. int
ORIGIN_FABRIC_ID The fabric from which the event originated. Retaining
this id as historical data.
int
SWITCH_PORT_ID Nullable foreign key. The FC port for which the event
occurred. This will only be populated for port events.
int
FCIP_CIRCUIT_ID Nullable foreign key. The FCIP tunnel circuit for which
the event occurred. This will only be populated for FCIP
tunnel events.
int
FRU_NAME For switch policy status events, the object name is
provided in the event and indicates the name of the
FRU affected. i.e. PS 1, Fan 2. As this FRU object name
is only provided for one category of events, making the
column nullable.
varchar 32
VM_ID Nullable foreign key. The VM for which the event
occurred. This will only be populated for vCenter
events.
int
TABLE 202 MAPS_EVENT_DETAILS
Field Definition Format Size
ID The primary key of the table. int
MAPS_EVENT_ID The corresponding maps_event. int
SWITCH_TIME The switch timestamp from the event. timestamp
RULE_NAME The name of the threshold rule. varchar 32
RULE_CONDITION The threshold condition in string format. i.e. CRC > 30 varchar 128
TIME_BASE The time base for the threshold. 0 - None, 1 - Minute, 2
- Hour, 3 - Day
int
ACTIONS A bit map for the actions configured for the rule. 0 -
None, 1 - RASLOG, 2 - SNMP, 4 - Email, 8 - Fence Port,
16 - SW_ST_DOWN, 32 - SW_ST_MARGINAL.
int
CURRENT_VALUE The current value of the measure that triggered the
violation.
varchar 32
TABLE 203 MAPS_EVENT_CAUSE_ACTION
Field Definition Format Size
VIOLATION_TYPE The type of the violation. i.e. CRC, ITW, as defined in
MapsConstants.
int
CAUSE Description of the probable cause of the MAPS
violation.
varchar 4096
ACTION Description of the recommended action for the MAPS
violation.
varchar 4096
TABLE 201 MAPS_EVENT (Continued)
Field Definition Format Size