Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1707

Advertising
background image

Brocade Network Advisor SAN User Manual

1655

53-1003154-01

Database tables and fields

H

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 293

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 294

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 295

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 292

PM_WIDGET_TIME_SERIES_ENTRY (Continued)

Field

Definition

Format

Size

Advertising