User Manual v12.3.0 Owner's manual

1624 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
TABLE 232 MAPS_EVENT
Field Definition Format Size
ID The primary key of the table. int
HOST_TIME The time at which the server processed the event. timestamp
CATEGORY The violations category. i.e. Port Health, Fabric Health,
etc.
int
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
FLOW_DEFINITION_ID Nullable foreign key. The NP flow definition for which
the event occurred. This will only be populated for flow
events
int
INTERFACE_ID Denotes interface_id for NOS interface related interface
violations. This will only be populated for NOS Ethernet
related port Events, for other FC ports of NOS
switch_port_id will be populated.
int
TABLE 233 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