Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1451
53-1002948-01
Database tables and fields
H
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 347 SNMP_EXPR_DATA_2HOUR
Field Definition Format Size
ID Unique generated database identifier. int
EXPRESSION_ID int
TARGET_TYPE smallint
TARGET_ID int
VALUE double
precision
TIME_IN_SECONDS int
COLLECTOR_ID int
TABLE 348 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 349 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 346 SNMP_EXPR_DATA_1DAY (Continued)
Field Definition Format Size