Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1708

Advertising
background image

1656

Brocade Network Advisor SAN User Manual

53-1003154-01

Database tables and fields

H

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 296

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 297

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 298

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 295

POE_THRESHOLD (Continued)

Field

Definition

Format

Size

Advertising