Brocade Network Advisor IP User Manual 1607
53-1003056-01
Views I
DEPLOYMENT_INFO
create or replace view DEPLOYMENT_INFO as
select
DEPLOYMENT_CONFIGURATION.ID as ID,
DEPLOYMENT_CONFIGURATION.NAME as NAME,
DEPLOYMENT_CONFIGURATION.DESCRIPTION as DESCRIPTION,
DEPLOYMENT_HANDLER.MODULE as MODULE,
DEPLOYMENT_HANDLER.SUB_MODULE as SUB_MODULE,
DEPLOYMENT_STATUS.DEPLOYMENT_TIME as DEPLOYMENT_TIME,
DEPLOYMENT_CONFIGURATION.DEPLOY_OPTION as DEPLOYMENT_OPTION,
DEPLOYMENT_STATUS.STATUS as STATUS,
DEPLOYMENT_STATUS.DEPLOYED_BY as DEPLOYED_BY,
DEPLOYMENT_CONFIGURATION.CREATED_BY as CREATOR,
DEPLOYMENT_CONFIGURATION.SCHEDULE_ENABLED as SCHEDULE_ENABLED,
DEPLOYMENT_CONFIGURATION.SNAPSHOT_ENABLED as SNAPSHOT_ENABLED,
SCHEDULE_ENTRY.TYPE as FREQUENCY,
DEPLOYMENT_CONFIGURATION.MANAGEMENT_FLAG,
DEPLOYMENT_HANDLER.PRIVILEGE_ID,
DEPLOYMENT_HANDLER.HANDLER_CLASS,
DEPLOYMENT_HANDLER.CLIENT_ACTION_HANDLER_CLASS,
DEPLOYMENT_STATUS.ID as STATUS_ID,
DEPLOYMENT_HANDLER.MODULE_DISPLAYNAME,
DEPLOYMENT_REPORT_TEMPLATE.HEADER,
DEPLOYMENT_REPORT_TEMPLATE.FOOTER
from
DEPLOYMENT_CONFIGURATION
join DEPLOYMENT_HANDLER on DEPLOYMENT_CONFIGURATION.DEPLOYMENT_HANDLER_ID
= DEPLOYMENT_HANDLER.ID
left outer join DEPLOYMENT_STATUS on
(DEPLOYMENT_STATUS.DEPLOYMENT_TIME =
(select
max(DEPLOYMENT_STATUS.DEPLOYMENT_TIME)
from
DEPLOYMENT_STATUS
where
DEPLOYMENT_STATUS.DEPLOYMENT_CONFIGURATION_ID =
DEPLOYMENT_CONFIGURATION.ID))
left outer join SCHEDULE_ENTRY on
SCHEDULE_ENTRY.IDENTITY = cast(DEPLOYMENT_CONFIGURATION.ID as
varchar(16))
and SCHEDULE_ENTRY.TABLE_NAME = 'DEPLOYMENT_CONFIGURATION'
left outer join DEPLOYMENT_REPORT_TEMPLATE on
DEPLOYMENT_REPORT_TEMPLATE.DEPLOYMENT_HANDLER_ID = DEPLOYMENT_HANDLER.ID;
DEPLOYMENT_LOG
create or replace view DEPLOYMENT_LOG as
select
DEPLOYMENT_CONFIGURATION.ID,
DEPLOYMENT_CONFIGURATION.NAME,
DEPLOYMENT_CONFIGURATION.DESCRIPTION,
DEPLOYMENT_HANDLER.MODULE,
DEPLOYMENT_HANDLER.SUB_MODULE,
DEPLOYMENT_STATUS.DEPLOYMENT_TIME,
DEPLOYMENT_CONFIGURATION.DEPLOY_OPTION as DEPLOYMENT_OPTION,
DEPLOYMENT_STATUS.STATUS, DEPLOYMENT_STATUS.DEPLOYED_BY,
DEPLOYMENT_CONFIGURATION.CREATED_BY as CREATOR,