User's Manual

1502 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TARGET_TYPE 0 - Device
1 - Port
smallint
TARGET_ID Stores device ID if taret_TYPE is Device, or interface
DB ID if target TYPE is port.
int
MEASURE_ID Measure table DB ID. int
MEASURE_INDEX Index value for a MIB variable. For scalar value it will
be empty.
varchar 256
TABLE 287 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 288 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 289 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
TABLE 286 PM_WIDGET_TIME_SERIES_ENTRY (Continued)
Field Definition Format Size