Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1181
53-1002696-01
Database tables and fields
H
TABLE 74 DEPLOYMENT_STATUS
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_CONFIGU
RATION_ID
Foreign Key References
DEPLOYMENT_CONFIGURATION(id).
Identifies the deployment configuration
int
DEPLOYMENT_TIME Start Time of the deployment (UTC) timestamp with time zone
STATUS Overall status of the deployment.
1-In Progress
2-Success
3-Failure
4-Partially failed
smallint
DEPLOYED_BY User who deployed the configuration varchar 255
STATUS_MESSAGE Overall Success/Failure status description txt
TRIGGER_SOURCE Maintains the source from which this
deployment was triggered such as Event Action
<Event policy name>, Manual and Scheduled
etc.
varchar 128
TABLE 75 DEPLOYMENT_TARGET_MAP
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_CONFIGU
RATION_ID
Foreign Key References
DEPLOYMENT_CONFIGURATION (id)
Identifies the deployment configuration this row
is applied
int
TARGET_ID Identifies the target. It will NOT have mapping
to any product table like device, etc
varchar 255
TARGET_TYPE_ID Foreign Key references TARGET_TYPE (id)
Identifies the target type
int
TARGET_PARENT_ID Identifies the parent of the target. If, switch,
device, port group, device group it will be same
as target id. If it is port/interfaces the parent id
will be the switch id
int
TABLE 76 DEVICE
Field Definition Format Size
DEVICE_ID Primary key for this table. int
IP_ADDRESS IP address of this device. varchar 255
ALIAS_NAME Device alias name. varchar 512
HOST_NAME Best matching host name obtained through the
device IP address.
varchar 512
SYS_NAME An administratively-assigned name for this
device.
varchar 255