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

Brocade Network Advisor SAN User Manual 1771
53-1003154-01
Views
H
VIRTUAL_SWITCH.PROTOCOL,
FABRIC_MEMBER.FABRIC_ID,
FABRIC_MEMBER.TRUSTED,
FABRIC_MEMBER.MISSING,
FABRIC_MEMBER.MISSING_TIME,
FABRIC.MANAGED as FABRIC_MANAGED,
FABRIC.PRINCIPAL_SWITCH_WWN,
FABRIC.SEED_SWITCH_WWN,
FABRIC.TYPE as FABRIC_TYPE
from
CORE_SWITCH,
VIRTUAL_SWITCH,
FABRIC_MEMBER,
FABRIC
where
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
and FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and FABRIC_MEMBER.FABRIC_ID = FABRIC.ID;
SWITCH_REPORT_INFO
CREATE OR REPLACE VIEW switch_report_info AS
SELECT core_switch.id AS physical_switch_id,
core_switch.name AS physical_switch_name, core_switch.ip_address,
core_switch.wwn AS physical_switch_wwn,
core_switch.operational_status AS physical_operational_status,
core_switch.type, core_switch.max_virtual_switches,
core_switch.num_virtual_switches, core_switch.firmware_version,
core_switch.vendor, core_switch.reachable, core_switch.unreachable_time,
core_switch.model, core_switch.syslog_registered,
core_switch.snmp_registered, core_switch.call_home_enabled,
core_switch.user_ip_address, core_switch.nic_profile_id,
core_switch.managing_server_ip_address, core_switch.vf_enabled,
core_switch.vf_supported,
core_switch.managed_element_id AS core_managed_element_id,
core_switch.nat_private_ip_address, core_switch.alternate_ip_address,
core_switch.mac_address, virtual_switch.id, virtual_switch.name,
virtual_switch.operational_status, virtual_switch.switch_mode,
virtual_switch.ad_capable, virtual_switch.wwn, virtual_switch.role,
virtual_switch.fcs_role, virtual_switch.domain_id,
virtual_switch.virtual_fabric_id, virtual_switch.base_switch,
virtual_switch.max_zone_config_size, virtual_switch.creation_time,
virtual_switch.last_update_time, virtual_switch.user_name,
virtual_switch.password, virtual_switch.management_state,
virtual_switch.state, virtual_switch.status, virtual_switch.status_reason,
virtual_switch.fabric_idid_mode, virtual_switch.logical_id,
virtual_switch.user_defined_value_1, virtual_switch.user_defined_value_2,
virtual_switch.user_defined_value_3, virtual_switch.interop_mode,
virtual_switch.crypto_capable, virtual_switch.fcr_capable,
virtual_switch.fcip_capable, virtual_switch.lf_enabled,
virtual_switch.fcoe_capable, virtual_switch.l2_capable,
virtual_switch.l3_capable, virtual_switch.default_logical_switch,
virtual_switch.features_supported, virtual_switch.fms_mode,
virtual_switch.dynamic_load_sharing, virtual_switch.port_based_routing,
virtual_switch.in_order_delivery, virtual_switch.insistent_did_mode,
virtual_switch.previous_operational_status, virtual_switch.last_scan_time,
virtual_switch.domain_mode_239, virtual_switch.domain_id_offset,
virtual_switch.discovered_port_count, virtual_switch.fcoe_login_enabled,
virtual_switch.last_port_membership_change,