Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1356 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
PRODUCT_ID This record will be per product. Hence this will
have the id of the product.
int
PRODUCT_TYPE_ID Foreign Key references TARGET_TYPE(id). This
identifies the PRODUCT_ID. (Whether it is
switch, device, etc).
int
STATUS Indicated the product deployment status
1-Aborted
2-Succesful
3-Partial Failure
4-Failed
smallint
MESSAGE Message to be displayed in the report. txt
ERROR_CODE Error code, can be used for i18n int
TABLE 147 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 148 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
TABLE 146 DEPLOYMENT_PRODUCT_STATUS (Continued)
Field Definition Format Size