beautypg.com

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

Page 2498

background image

2426

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Database tables and fields

I

TIME_IN_SECONDS

Time, in seconds, at which the record was inserted in
seconds.

int

COLLECTOR_ID

DB ID of the collector object used for collection.

int

TABLE 377

SNMP_EXPR_DATA_30MIN

Field

Definition

Format

Size

ID

Primary key autogenerated ID

int

EXPRESSION_ID

DB ID of the expression object used for collection

int

TARGET_TYPE

Target/Source type can be device:0 or
interface/ports:1'

smallint

TARGET_ID

DB Id of the target which can be device or interface

int

VALUE

Value collected by the engine'

double
precision

TIME_IN_SECONDS

Time at which collection occured in seconds

int

COLLECTOR_ID

DB Id of the collector object used for collection

int

TABLE 378

SNMP_EXPRESSION

Field

Definition

Format

Size

EXPRESSION_ID Primary key column.

serial

NAME

Name of the expression.

varchar

64

DESCRIPTION

Description of the expression.

varchar

512

EQUATION

Equation of the expression.

varchar

1024

UNIT

Unit that is used for displaying the chart.

varchar

64

IS_TRANSIENT

Explicitly identified whether expressions is used for
Real time collector or not. A transient expression will
not be allowed for user editing.

numeric

(1,0)

TABLE 379

SNMP_PROFILE

Field

Definition

Format

Size

NAME*

A text string representing a set of SNMP agent
profile. When created, one or more virtual switches
could refer to this profile for its SNMP credentials
unless a unique set of SNMP credentials has been
defined in SNMP_CREDENTIAL.

varchar

256

PORT_NUMBER

Port number of the SNMP agent on the switch for
get and set requests

smallint

RETRY_COUNT

Number of times to retry if get/set request to the
SNMP agent times out. Default value is 3.

smallint

TIMEOUT

Timeout value in seconds before for a get/set
request to the SNMP agent. Default value is 5.

smallint

TABLE 376

SNMP_EXPR_DATA_1DAY (Continued)

Field

Definition

Format

Size