Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1270 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 248 PM_WIDGET_TOP_N_COLLECTOR_ENTRY
Field Definition Format Size
WIDGET_ID The ID of the widget definition. int
COLLECTOR_ID ID of the PERF_COLLECTOR. int
MEASURE_ID Measure table DB ID. int
DIRECTION The direction of the port measure.
0 - default (not used)
1 - receiving
2 -transmitting
smallint
TABLE 249 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 250 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