Brocade Communications Systems IP250 Database tables and fields Poethreshold, Poethresholdevent

		Database tables and fields		I
TABLE 289 POE_THRESHOLD (Continued)
Field	Definition		Format	Size
CONDITION	Condition like ><= to the defined threshold value at		smallint
	which threshold is triggered
	• 0 > (Greater Than)
	•	1 >= (Greater Than or Equal)
	•	2 < (Less Than)
	•	3 < = (Less Than or Equal)
	•	4 = (Equal to)
	•	5 != (Not Equal To)
SEVERITY	Severity level of defined threshold on port and		int
	product Poe measures.
TABLE 290 POE_THRESHOLD_EVENT
Field	Definition		Format	Size
ID	Unique generated database identifier.		serial
TIME_STAMP	This field indicates the time at which a particular		bigint
	threshold was triggered.
THRESHOLD_ID	This is the foreign key reference key to the		int
	POE_THRESHOLD Table.
EVENT_VALUE	Value of the measure at which threshold was		double
	triggered.		precision
TABLE 291 POLICY_RULE
Field	Definition		Format	Size
ID	Primary key for the table.		int
NAME	Rule name.		varchar	255
DESCRIPTION	Rule description.		varchar	1024
TYPE	Policy Monitor rule type. For e.g. 1-zoning status		smallint
	check, 2-orphaned zone check, 3-fan in ratio check,
	4- event registration check... 10-Configuration Rule,
	etc.
CATEGORY	Policy Monitor rule category. For example, 0 -		smallint
	pre-defined, 1 - user-defined for configuration rule
	check.

TABLE 292 POLICY_RULE_MAP

Field	Definition	Format	Size
ID	Primary key for the table.	int
DEPLOYMENT_CONFIGURA	Foreign key reference to	int
TION_ID	DEPLOYMENT_CONFIGURATION.ID.
POLICY_RULE_ID	Foreign key reference to POLICY_RULE.ID.	int
ATTRIBUTES	Attributes for pre-canned rules, this is name value	varchar	255
	pair string, use & as delimiter. For example
	minConn=2&maxConn=5.

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