Brocade Communications Systems Network Advisor 12.0.0, Руководство пользователя

Страница: 1414 / 1505

1366 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
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,
DEPLOYMENT_CONFIGURATION.SCHEDULE_ENABLED,
DEPLOYMENT_CONFIGURATION.SNAPSHOT_ENABLED,
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_STATUS.TRIGGER_SOURCE as TRIGGER_SOURCE,
DEPLOYMENT_REPORT_TEMPLATE.HEADER,
DEPLOYMENT_REPORT_TEMPLATE.FOOTER
from
DEPLOYMENT_CONFIGURATION
inner join DEPLOYMENT_HANDLER
on DEPLOYMENT_CONFIGURATION.DEPLOYMENT_HANDLER_ID =
DEPLOYMENT_HANDLER.ID
inner join DEPLOYMENT_STATUS
on DEPLOYMENT_CONFIGURATION.ID =
DEPLOYMENT_STATUS.DEPLOYMENT_CONFIGURATION_ID