User's Manual

1458 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TABLE 173 HBA_TARGET
Field Definition Format size
DEVICE_PORT_ID Primary key from the Device port table int
HBA_REMOTE_PORT_LUN_
ID
Primary key from the HBA Remote port lun table int
BOOT_LUN Flag to indicate of the LUN is bootable.
The default value is -1.
smallint
TRUSTED Denotes whether target is trusted or not. 0 denotes
untrusted and 1 is for trusted.
smallint
CREATION_TIME Creation time of the entry timestamp
MISSING Flag to indicate if the remote LUN is missing.
The default value is 0.
smallint
MISSING_TIME Time at which the LUN is marked missing. timestamp
TARGET_ID The identifier of the target device as reported by
each HBA port.
The default value is 0.
int
TABLE 174 HEALTH_STATUS
Field Definition Format Size
ID serial
DEPLOYMENT_STATUS_ID Identifies the execution cycle for the deployment. int
RULE_ID Policy Monitor rule ID. smallint
RULE_DESCRIPTION Description of what the check is about. varchar 255
TABLE 175 HEALTH_TARGET_STATUS
Field Definition Format Size
ID serial
HEALTH_STATUS_ID Identifies the execution cycle for the deployment. int
TARGET_ID In case of fabric, this is fabric DB ID; for switch, this is
switch DB ID; for host, this is host db ID.
int
TARGET_TYPE smallint
STATUS 0 - Failed
1 - Successful
smallint
MESSAGE Check result message. varchar 16384
MESSAGE_TYPE text
LEGACY_NAME Target legacy name. varchar 256
TABLE 176 HOST_DISCOVERY_OPTION
Field Definition Format Size
ID Auto generated primary key int
DISCOVER_JSON Flag to indicate JSON agent based discovery.
The default value is 1.
smallint