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

Brocade Network Advisor SAN User Manual 1795
53-1003154-01
Views
H
vs.domain_id As edge_virtual_switch_domain_id,
sp.category AS sp_category,
sp.licensed AS sp_licensed,
sp.name AS sp_name,
sp.slot_number AS sp_slot_number,
sp.port_number AS sp_port_number,
sp.port_id AS sp_port_id,
sp.port_index AS sp_port_index,
sp.area_id AS sp_area_id,
sp.mac_address AS sp_mac_address,
sp.status AS sp_status,
sp.state AS sp_state,
cs.model AS edge_core_switch_smodel,
cs.ip_address AS edge_core_switch_ip_address,
cs.wwn AS edge_core_switch_physical_switch_wwn,
cs.operational_status AS edge_core_switch_operational_status,
cs.name AS edge_core_switch_name,
cs.type AS edge_core_switch_type,
cs.model AS edge_core_switch_model,
cs.vendor AS edge_core_switch_vendor
from FABRIC, DEVICE_PORT_INFO
LEFT JOIN device_node dn ON DEVICE_PORT_INFO.node_id = dn.id
LEFT JOIN switch_port sp ON DEVICE_PORT_INFO.switch_port_wwn = sp.wwn
LEFT JOIN virtual_switch vs ON sp.virtual_switch_id = vs.id
LEFT JOIN core_switch cs ON vs.core_switch_id = cs.id
where FABRIC.ID = DEVICE_PORT_INFO.FABRIC_ID and FABRIC.TYPE not in (65, 66)
)as ADAPTER_PORT_FABRIC_MAP on ADAPTER_PORT_FABRIC_MAP.ADAPTER_PORT_WWN =
DEVICE_PORT_INFO.WWN,
(select DEVICE_PORT_ID, CONFIGURED_STATE, CONFIGURED_SPEED, CONFIGURED_TOPOLOGY,
MAX_SPEED_SUPPORTED, OPERATING_STATE, OPERATING_TOPOLOGY, SUPPORTED_FC4_TYPES,
SUPPORTED_COS, TRUSTED, CREATION_TIME, MISSING, MISSING_TIME,
OPERATING_SPEED, CNA_PORT_ID, PORT_NWWN, PHYSICAL_PORT_WWN, SWITCH_IP,
PRINCIPAL_SWITCH_WWN, HBA_ID, PORT_NUMBER, NAME, FACTORY_PORT_WWN,
FACTORY_NODE_WWN, PREBOOT_CREATED, MAX_BANDWIDTH, PCIF_INDEX,
MAX_PCIF, SYNTHETIC_FC, 'FC' as TYPE, 0 as ETH_PORT_ID, '' as ETH_DEV, '' as
MAC_ADDRESS
from HBA_PORT
union
select DEVICE_PORT_ID, CONFIGURED_STATE, CONFIGURED_SPEED, CONFIGURED_TOPOLOGY,
MAX_SPEED_SUPPORTED, OPERATING_STATE, OPERATING_TOPOLOGY, SUPPORTED_FC4_TYPES,
SUPPORTED_COS, HBA_PORT.TRUSTED, CNA_ETH_PORT.CREATION_TIME, HBA_PORT.MISSING,
HBA_PORT.MISSING_TIME,
OPERATING_SPEED, HBA_PORT.CNA_PORT_ID, PORT_NWWN, PHYSICAL_PORT_WWN, SWITCH_IP,
PRINCIPAL_SWITCH_WWN, HBA_PORT.HBA_ID, HBA_PORT.PORT_NUMBER, CNA_PORT.NAME,
HBA_PORT.FACTORY_PORT_WWN,
HBA_PORT.FACTORY_NODE_WWN, HBA_PORT.PREBOOT_CREATED,
CNA_ETH_PORT.MAX_BANDWIDTH, CNA_ETH_PORT.PCIF_INDEX,
CNA_ETH_PORT.MAX_PCIF, SYNTHETIC_FC, 'IP-Port' as TYPE,
CNA_ETH_PORT.ID as ETH_PORT_ID, CNA_ETH_PORT.ETH_DEV, CNA_ETH_PORT.MAC_ADDRESS
from DEVICE_PORT, HBA_PORT, CNA_PORT, CNA_ETH_PORT
where DEVICE_PORT.ID = HBA_PORT.DEVICE_PORT_ID and HBA_PORT.CNA_PORT_ID =