Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1132 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TIME_IN_SECONDS int
COLLECTOR_ID int
TABLE 378 SNMP_EXPR_DATA_2HOUR
Field Definition Format Size
ID int
EXPRESSION_ID int
TARGET_TYPE smallint
TARGET_ID int
VALUE double
precision
TIME_IN_SECONDS int
COLLECTOR_ID int
TABLE 379 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 380 SNMP_TRAP_CREDENTIAL
Field Definition Format Size
ID PK for the table to uniquely identify the record int
VERSION to identify the version of Credentials: v1v2c and v3
are the values
varchar 6
COMMUNITY_STRING to decode the v1/v2c traps varchar 64
USER_NAME user access name for v3 trap varchar 64
AUTH_PROTOCOL authentication protocol used for v3 traps varchar 16
AUTH_PASSWORD authentication password for v3 traps varchar 64
PRIV_PROTOCOL privacy protocol used for v3 traps varchar 16
PRIV_PASSWORD varchar 64
POSITION_ order of credentials to authenticate v1/v2c or v3
traps
int
TABLE 377 SNMP_EXPR_DATA_1DAY (Continued)
Field Definition Format Size