Brocade Communications Systems IP250 user manual Mapsevent, Macgroupmember, Managedelement

	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

TABLE 225 MANAGED_ELEMENT

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.

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,	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