Macgroup, Mapsevent | Brocade Communications Systems IP250 guide

	Database tables and fields		I
TABLE 223 MAC_GROUP

Field	Definition	Format	Size

MAC_GROUP_ID	The ID will represent any one of the following.	Int
	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.

TYPE	This indicates if the mac group is internal to BNA or	int
	mapped to device. 0- internal mac group, 1- external
	mac group defined in network OS switch, 2- User
	defined mac groups.

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

Field	Definition	Format	Size

ID	An ID that is unique across managed elements of all	int
	types: SAN physical switches, SAN logical switches, IP
	switches, and hosts. Also the primary key for the
	MANAGED_ELEMENT table.

PLACEHOLDER	Not used. iBatis/Abator requires at least one non-serial	int
	column to generate correct objects. The default value is
	0.

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,	int
	etc.

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	int
	this id as historical data.

Brocade Network Advisor IP User Manual	1477
53-1003056-01