Brocade Communications Systems IP250 Deploymentinfo, Deploymentlog, Deploymentconfiguration

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,

Brocade Network Advisor IP User Manual	1607
53-1003056-01