Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1841 / 1940

Brocade Network Advisor SAN User Manual 1789
53-1003154-01
Views
H
birtreport_schedule_config.deployment_id,
birtreport_schedule_config.email_delivery,
birtreport_schedule_config.folder_delivery,
CREATE OR REPLACE VIEW generated_birtreport_info AS
SELECT generated_birtreport.id AS generated_report_id,
generated_birtreport.file_name, generated_birtreport.rptdoc_store_location,
generated_birtreport.generate_time, generated_birtreport.format,
generated_birtreport.flagged, generated_birtreport.shared,
generated_birtreport.report_template_id,
generated_birtreport.report_generation_status,
generated_birtreport.report_generation_status_description,
report_template.name AS report_template_name,
report_template.title AS report_template_title,
report_template.created_time AS report_template_creation_time,
report_template.created_by AS template_created_by,
report_template.report_type AS template_type,
report_template.parameterized AS template_is_parameterized,
report_template.category AS template_category,
report_template.shared AS template_is_shared,
generated_birtreport.generated_by AS report_generated_by_user_id,
user_.name AS report_generated_by_user_name,
user_.email AS report_generated_by_user_email,
generated_birtreport.scheduled, generated_birtreport.schedule_id,
birtreport_schedule_config.name AS schedule_name,
birtreport_schedule_config.report_store_location,
birtreport_schedule_config.format_type AS scheduled_report_format,
birtreport_schedule_config.deployment_id,
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.last_modified_time AS
last_modified_time_for_schedule,
birtreport_schedule_config.created_time AS created_time_for_schedule
FROM generated_birtreport
LEFT JOIN report_template ON generated_birtreport.report_template_id =
report_template.id
LEFT JOIN user_ ON generated_birtreport.generated_by = user_.id
LEFT JOIN birtreport_schedule_config ON generated_birtreport.schedule_id =
birtreport_schedule_config.id;
HBA_PORT_DETAILS_INFO
create or replace view HBA_PORT_DETAILS_INFO as
select
HBA_PORT.DEVICE_PORT_ID,
HBA_PORT.CONFIGURED_STATE,
HBA_PORT.CONFIGURED_SPEED,
HBA_PORT.CONFIGURED_TOPOLOGY,
HBA_PORT.MAX_SPEED_SUPPORTED,
HBA_PORT.OPERATING_STATE,
HBA_PORT.OPERATING_TOPOLOGY,
HBA_PORT.SUPPORTED_FC4_TYPES,
HBA_PORT.SUPPORTED_COS,
HBA_PORT.TRUSTED as HBA_PORT_TRUSTED,