Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1375
53-1002948-01
Database tables and fields
H
TABLE 171 EVENT_DETAILS
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_ID Database ID of the EVENT instance. int
FIRST_OCCURRENCE_SWI
TCH_TIME
Indicates the first occurrence switch timestamp of the
event.
timestamp
LAST_OCCURRENCE_SWIT
CH_TIME
Indicates the last occurrence switch timestamp of the
event.
timestamp
CONTRIBUTORS Indicates the contributing factor for the event resulted
due to a status change of the switch.
varchar 512
OPERATIONAL_STATUS Indicates the operational Status of the product
associated with the event.
varchar 255
NODE_WWN Unique World Wide Number for the product. varchar 23
PORT_WWN Unique World Wide Number for the port for which the
event was generated.
varchar 23
OID Indicates the Object ID of the Trap or Syslog. varchar 50
VIRTUAL_FABRIC_ID Indicates the Virtual Fabric id of the switch which
triggered the event.
smallint
UNIT Indicates the Unit number of the Chassis from which
the event was triggered.
smallint
SLOT Indicates the blade or the slot number in which the
port is present.
int
PORT indicates the switch port number for which the event
was generated.
int
PRODUCT_ADDRESS Indicates the IP Address of the Product from which the
event is originated.
varchar
RAS_LOG_ID Indicates the RASLOG Id of the RASLOG event. varchar 20
INTERFACE_TYPE Indicates the type of the interface – Possible Values:
Ethernet Port-0, FC Port-1.
smallint
USER_NAME Captures the user information from audit Syslog
messages.
Varchar 512
PORT_NAME Shows the PortName for the corresponding port. Varchar 255
MAC_ADDRESS 'Indicates the MAC address of the Access Point from
which this event is received. If the event is received
from the wireless controller or any other products, this
will be empty.';
varchar 64
TABLE 172 EVENT_INSTANCE
Field Definition Format Size
ID Unique generated database identifier. int
EVENT_POLICY_ID Foreign Key to Event_Policy Table int
EVENT_KEY A String Key string which identifies a specific instance
of an Event.
varchar 64