beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2514

background image

2442

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Database tables and fields

I

MEASURE_ID

ID of the measure.

int

TARGET_ID

Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.

int

COLLECTOR_ID

ID of the data_collector.

int

MEASURE_INDEX

'Stores the index_map value in case of anexpression. varchar

256

ME_ID

ME_ID of the target.

int

VALUE

30 mins aggregated data.

double
precision

TABLE 405

TIME_SERIES_DATA_1DAY

Field

Definition

Format

Size

TIME_IN_SECONDS

Time when the record is inserted.

int

TARGET_TYPE

Target type of the PM collector data. For device level
collector the target type is 0, for port level it is 1.

smallint

MEASURE_ID

ID of the measure.

int

TARGET_ID

Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.

int

COLLECTOR_ID

ID of the data_collector.

int

MEASURE_INDEX

Stores the index_map value in case of an expression. varchar

256

ME_ID

ME_ID of the target.

int

VALUE

30 mins aggregated data.

double
precision

TABLE 406

TIME_SERIES_DATA_2HOUR

Field

Definition

Format

Size

TIME_IN_SECONDS

Time when the record is inserted.

int

TARGET_TYPE

Target type of the PM collector data. For device level
collector the target type is 0, for port level it is 1.

smallint

MEASURE_ID

ID of the measure.

int

TARGET_ID

Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.

int

COLLECTOR_ID

ID of the data_collector.

int

MEASURE_INDEX

Stores the index_map value in case of an expression. varchar

256

ME_ID

ME_ID of the target.

int

VALUE

30 mins aggregated data.

double
precision

TABLE 404

TIME_SERIES_DATA (Continued)

Field

Definition

Format

Size