Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1229 / 1505

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