User's Manual

1532 Brocade Network Advisor IP User Manual
53-1003056-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 369 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 370 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 371 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 368 SNMP_EXPR_DATA_1DAY (Continued)
Field Definition Format Size