
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,
Summary of Contents for Network Advisor 12.3.0
Page 4: ...iv Brocade Network Advisor SAN User Manual 53 1003154 01...
Page 86: ...34 Brocade Network Advisor SAN User Manual 53 1003154 01 Uninstalling a patch 2...
Page 190: ...138 Brocade Network Advisor SAN User Manual 53 1003154 01 Fabric tracking 4...
Page 216: ...164 Brocade Network Advisor SAN User Manual 53 1003154 01 User profiles 5...
Page 612: ...560 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting Host port mapping 13...
Page 620: ...568 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting storage port mapping 14...
Page 720: ...668 Brocade Network Advisor SAN User Manual 53 1003154 01 Security configuration deployment 17...
Page 744: ...692 Brocade Network Advisor SAN User Manual 53 1003154 01 Configuring Virtual Fabrics 19...
Page 1068: ...1016 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing thresholds 24...
Page 1098: ...1046 Brocade Network Advisor SAN User Manual 53 1003154 01 Swapping blades 25...
Page 1176: ...1124 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN connection utilization 28...
Page 1378: ...1326 Brocade Network Advisor SAN User Manual 53 1003154 01 Event logs 32...
Page 1448: ...1396 Brocade Network Advisor SAN User Manual 53 1003154 01 Upload failure data capture 34...
Page 1490: ...1438 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN shortcut menus A...
Page 1494: ...1442 Brocade Network Advisor SAN User Manual 53 1003154 01 Call Home Event Tables B...
Page 1524: ...1472 Brocade Network Advisor SAN User Manual 53 1003154 01 About Roles and Access Levels D...
Page 1552: ...1500 Brocade Network Advisor SAN User Manual 53 1003154 01 Regular Expressions F...
Page 1920: ...1868 Brocade Network Advisor SAN User Manual 53 1003154 01 Views H...