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

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,