Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2188)

Brocade Network Advisor SAN + IP User Manual 2151
53-1002949-01
Database tables and fields
I
TABLE 331 PM_WIDGET_USER_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
USER_ID ID of the user who is using the widget definition. int
TABLE 332 POE_THRESHOLD
Field Definition Format Size
ID Unique generated database identifier. serial
TYPE This field indicates if the threshold is defined for
product and port level measure.
•
0 = product level
•
1 = port level
smallint
DEVICE_ID This is the foreign key reference key to the Device
Table. int
INTERFACE_ID This is the foreign key reference key to the Interface
Table. int
ENABLED Flag to indicate of defined threshold is enabled or
not.
•
0 = disabled
•
1 = enabled
smallint
VALUE Value of the measure at which threshold is defined. double
precision
INTERVAL Time interval at which threshold is triggered. int
MEASURE Product and port level poe measure definition. smallint
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 333 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