Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1359 / 1505

Brocade Network Advisor SAN User Manual 1311
53-1002696-01
Database tables and fields
H
TABLE 341 SYSTEM_PROPERTY
Field Definition Format Size
NAME* The name of the property. char 64
VALUE The value for the property. varchar 2048
TABLE 342 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 343
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 344
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 345 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