User's Manual

Brocade Network Advisor IP User Manual 1503
53-1003056-01
Database tables and fields
I
CONDITION Condition like ><= to the defined threshold value at
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)
smallint
SEVERITY Severity level of defined threshold on port and
product Poe measures.
int
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
threshold was triggered.
bigint
THRESHOLD_ID This is the foreign key reference key to the
POE_THRESHOLD Table.
int
EVENT_VALUE Value of the measure at which threshold was
triggered.
double
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
check, 2-orphaned zone check, 3-fan in ratio check,
4- event registration check... 10-Configuration Rule,
etc.
smallint
CATEGORY Policy Monitor rule category. For example, 0 -
pre-defined, 1 - user-defined for configuration rule
check.
smallint
TABLE 292 POLICY_RULE_MAP
Field Definition Format Size
ID Primary key for the table. int
DEPLOYMENT_CONFIGURA
TION_ID
Foreign key reference to
DEPLOYMENT_CONFIGURATION.ID.
int
POLICY_RULE_ID Foreign key reference to POLICY_RULE.ID. int
ATTRIBUTES Attributes for pre-canned rules, this is name value
pair string, use & as delimiter. For example
minConn=2&maxConn=5.
varchar 255
TABLE 289 POE_THRESHOLD (Continued)
Field Definition Format Size