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

1758 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
BIRTREPORT_SCHEDULE_INFO
CREATE OR REPLACE VIEW birtreport_schedule_info AS
SELECT birtreport_schedule_config.id AS schedule_id,
birtreport_schedule_config.name AS schedule_name,
birtreport_schedule_config.report_store_location,
birtreport_schedule_config.overwrite,
birtreport_schedule_config.format_type,
birtreport_schedule_config.created_by AS
birtreport_schedule_config_created_by,
birtreport_schedule_config.email_delivery,
birtreport_schedule_config.folder_delivery,
birtreport_schedule_config.email_recipients,
birtreport_schedule_config.email_from,
birtreport_schedule_config.email_replyto,
birtreport_schedule_config.email_subject,
birtreport_schedule_config.email_prologue,
birtreport_schedule_config.email_epilogue,
birtreport_schedule_config.created_time AS
birtreport_schedule_config_created_time,
birtreport_schedule_config.last_modified_time AS
birtreport_schedule_config_last_modified_time,
birtreport_schedule_config.deployment_id,
deployment_configuration.name AS deploment_configuration_name,
deployment_configuration.configuration_type,
deployment_configuration.deploy_option,
deployment_configuration.deployment_handler_id,
deployment_configuration.schedule_enabled,
deployment_configuration.snapshot_enabled,
deployment_configuration.cli_template_id,
deployment_configuration.snapshot_setting,
deployment_configuration.post_deployment_delay,
deployment_configuration.created_by AS user_id_who_created_schedule,
deployment_configuration.last_modified_by AS
deplyment_config_last_modified_by,
deployment_configuration.management_flag,
deployment_configuration.description AS deployment_config_description,
deployment_status.id AS deploment_status_id,
deployment_status.deployment_time, deployment_status.status AS
deployment_status_status,
deployment_status.status_message AS deployment_status_status_message,
deployment_status.trigger_source,
schedule_entry.schedule_entry_id, schedule_entry.module,
schedule_entry.user_id, schedule_entry.minutes, schedule_entry.hours,
schedule_entry.week_days, schedule_entry.days, schedule_entry.months,
schedule_entry.years, schedule_entry.type AS schedule_entry_type,
schedule_entry.status AS status_from_schedule_entry,
schedule_entry.duration, schedule_entry.table_name
FROM birtreport_schedule_config
JOIN deployment_configuration ON birtreport_schedule_config.deployment_id =
deployment_configuration.id
LEFT JOIN deployment_status ON deployment_configuration.id =