Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1816)

1764 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_CANVAS_ID,
DASHBOARD_CANVAS_PREFERENCE.VISIBLE,
DASHBOARD_CANVAS_PREFERENCE.TIME_SCOPE,
DASHBOARD_CANVAS_PREFERENCE.USER_ID
from
DASHBOARD,
DASHBOARD_CANVAS,
DASHBOARD_CANVAS_PREFERENCE
where
DASHBOARD.ID = DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_ID
and DASHBOARD_CANVAS.ID = DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_CANVAS_ID;
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;