User's Manual

Brocade Network Advisor IP User Manual 1477
53-1003056-01
Database tables and fields
I
MAC_GROUP_ID The ID will represent any one of the following.
1 A cluster wide unique identifier defined in
Network OS switch to be used in mac-based
GVLAN classification at access port. Allowed
range is 0 through 500 both inclusive.
2 INTERNAL GROUP ID - A dummy group ID (-1),
used to represent one or more mac addresses
that can be associated with a GVLAN.
3 CUSTOM MAC GROUP ID: Reserved for future
usage if Network Advisor provides an option
through UI to create MAC GROUPs.
Int
TYPE This indicates if the mac group is internal to BNA or
mapped to device. 0- internal mac group, 1- external
mac group defined in network OS switch, 2- User
defined mac groups.
int
TABLE 224 MAC_GROUP_MEMBER
Field Definition Format Size
ID Primary Key. Sequence number of the records. int
MAC_GROUP_DB_ID Foreign Key Reference to the MAC_GROUP table. int
MAC_ADDRESS Mac Address that belongs to the Mac group. varchar 64
MASK Mask applied on the mac address. varchar 64
TABLE 225 MANAGED_ELEMENT
Field Definition Format Size
ID An ID that is unique across managed elements of all
types: SAN physical switches, SAN logical switches, IP
switches, and hosts. Also the primary key for the
MANAGED_ELEMENT table.
int
PLACEHOLDER Not used. iBatis/Abator requires at least one non-serial
column to generate correct objects. The default value is
0.
int
TABLE 226 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
TABLE 223 MAC_GROUP
Field Definition Format Size