
1794
Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
ADAPTER_PORT_FAA_STATUS,
case when (HBA_PORT_DETAIL.WWN_SOURCE is null or HBA_PORT_DETAIL.WWN_SOURCE = '')
then 'NA' else HBA_PORT_DETAIL.WWN_SOURCE end as ADAPTER_PORT_WWN_SOURCE,
HBA_PORT_DETAIL.BOOT_OVER_SAN as ADAPTER_PORT_BOOT_OVER_SAN,
ADAPTER_PORT.MAX_SPEED_SUPPORTED as ADAPTER_PORT_MAX_SPEED_SUPPORTED,
ADAPTER_PORT.OPERATING_STATE as PORT_OPERATING_STATE,
ADAPTER_PORT_COUNT.PORT_COUNT as HBA_PORT_COUNT,
HBA.ID as HBA_PORT_ID,
ADAPTER_PORT_FABRIC_MAP.FABRIC_NAME,
ADAPTER_PORT_FABRIC_MAP.FABRIC_ID,
ADAPTER_PORT_FABRIC_MAP.FABRIC_PRINCIPAL_SWITCH_WWN,
ADAPTER_PORT_FABRIC_MAP.FABRIC_SEED_SWITCH_WWN,
ADAPTER_PORT_FABRIC_MAP. device_node_id,
ADAPTER_PORT_FABRIC_MAP. virtual_swcith_id,
ADAPTER_PORT_FABRIC_MAP.edge_virtual_switch_wwn,
ADAPTER_PORT_FABRIC_MAP.edge_switch_name,
ADAPTER_PORT_FABRIC_MAP.edge_switch_virtual_fabric_id,
ADAPTER_PORT_FABRIC_MAP.edge_virtual_switch_monitored,
ADAPTER_PORT_FABRIC_MAP.edge_virtual_switch_domain_id,
ADAPTER_PORT_FABRIC_MAP.sp_category,
ADAPTER_PORT_FABRIC_MAP.sp_licensed,
ADAPTER_PORT_FABRIC_MAP.sp_name,
ADAPTER_PORT_FABRIC_MAP.sp_slot_number,
ADAPTER_PORT_FABRIC_MAP.sp_port_number,
ADAPTER_PORT_FABRIC_MAP.sp_port_id,
ADAPTER_PORT_FABRIC_MAP.sp_port_index,
ADAPTER_PORT_FABRIC_MAP.sp_area_id,
ADAPTER_PORT_FABRIC_MAP.sp_mac_address,
ADAPTER_PORT_FABRIC_MAP.sp_status,
ADAPTER_PORT_FABRIC_MAP.sp_state,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_smodel,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_ip_address,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_physical_switch_wwn,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_operational_status,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_name,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_type,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_model,
ADAPTER_PORT_FABRIC_MAP.edge_core_switch_vendor
from
DEVICE_ENCLOSURE,
HBA left join USER_DEFINED_DEVICE_DETAIL on (HBA.WWN =
USER_DEFINED_DEVICE_DETAIL.WWN),
HBA_PORT_DETAIL,
DEVICE_PORT_INFO left join
(select FABRIC.ID as FABRIC_ID, FABRIC.NAME as FABRIC_NAME, DEVICE_PORT_INFO.WWN
as
ADAPTER_PORT_WWN, FABRIC.SEED_SWITCH_WWN AS
FABRIC_SEED_SWITCH_WWN,FABRIC.PRINCIPAL_SWITCH_WWN AS
FABRIC_PRINCIPAL_SWITCH_WWN , dn.id As device_node_id, vs.id As
virtual_swcith_id,
vs.wwn AS edge_virtual_switch_wwn,
vs.name AS edge_switch_name,
vs.virtual_fabric_id AS edge_switch_virtual_fabric_id,
vs.monitored AS edge_virtual_switch_monitored,
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...