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

Brocade Network Advisor SAN User Manual 1461
53-1002948-01
Database tables and fields
H
TABLE 365 TARGET_TYPE
Field Definition Format Size
ID Unique generated database identifier. serial
TYPE Type of the target device. Some possible values are
• Switch
• Device
• Port
• Host
• Port Group
• Product Group
• VLAN
• Fabric
varchar 64
TABLE 366 THIRD_PARTY_DEVICE
Field Definition Format Size
DEVICE_ID Primary key for this table. int
DEVICE_TYPE Type of the third party device. As of now, we have two
types Wireless Location Manager and LANcope
device.
varchar 64
TABLE 367 THRESHOLD_MEASURE
Field Definition Format Size
MEASURE_ID* References the ID In PM_MEASURE table, where all
measures are defined.
int
HIGH_BOUNDARY Configured high boundary threshold value for
measure ID.
int
LOW_BOUNDARY Configured low boundary threshold value for
measure ID.
int
BUFFER_SIZE Configured buffer size for measure ID. int
POLICY_ID* References the ID in THRESHOLD_POLICY table. int
TABLE 368 TIME_SERIES_DATA
Field Definition Format Size
TIME_IN_SECONDS Time when value of the measure retrieved from the
corresponding target.
int
TARGET_TYPE Target type of the PM collector data. For device level
collector the target type is 0, for port level it is 1.
smallint
MEASURE_ID ID of the measure. int
TARGET_ID Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.
int
COLLECTOR_ID ID of the data_collector. int
MEASURE_INDEX 'Stores the index_map value in case of anexpression. varchar 256