Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1297
53-1002696-01
Database tables and fields
H
TARGET_TYPE smallint
TARGET_ID int
VALUE double
precision
TIME_IN_SECONDS int
COLLECTOR_ID int
TABLE 321 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 322 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 323 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
TABLE 320 SNMP_EXPR_DATA_2HOUR (Continued)
Field Definition Format Size