beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2420

background image

2348

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Database tables and fields

I

TABLE 176

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 177

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 178

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 179

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