Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2613)

Brocade Network Advisor SAN + IP User Manual 2541
53-1003155-01
Views
I
edge_switch_port.health AS edge_switch_port_health,
edge_switch_port.status_message AS edge_switch_port_status_message,
edge_switch_port.category AS edge_switch_port_category,
edge_switch_port.licensed AS edge_switch_port_licensed,
edge_switch_port.type AS edge_switch_port_type,
edge_switch_port.kind AS edge_switch_port_kind,
edge_switch_port.physical_port AS edge_switch_port_physical_port,
edge_switch_port.trunked AS edge_switch_port_trunked,
edge_switch_port.trunk_master AS edge_switch_port_trunk_master,
edge_switch_port.master_port_number AS edge_switch_port_master_port_number,
edge_switch_port.identifier AS edge_port_identifier,
edge_vs.id AS edge_vs_id,
edge_vs.wwn AS edge_virtual_switch_wwn,
edge_vs.name AS edge_switch_name,
edge_vs.virtual_fabric_id AS edge_switch_virtual_fabric_id,
edge_vs.operational_status AS edge_switch_operational_status,
edge_vs.state AS edge_switch_state,
edge_vs.status AS edge_switch_status,
edge_vs.status_reason AS edge_switch_status_reason,
edge_vs.core_switch_id AS edge_core_switch_id,
edge_vs.base_switch AS edge_base_switch,
edge_vs.management_state AS edge_virtual_switch_management_state,
edge_vs.monitored AS edge_virtual_switch_monitored,
edge_vs.domain_id As edge_virtual_switch_domain_id,
edge_cs.model AS edge_core_switch_smodel,
edge_cs.ip_address AS edge_core_switch_ip_address,
edge_cs.wwn AS edge_core_switch_physical_switch_wwn,
edge_cs.operational_status AS edge_core_switch_operational_status,
edge_cs.name AS edge_core_switch_name,
edge_cs.type AS edge_core_switch_type,
edge_cs.model AS edge_core_switch_model,
edge_cs.vendor AS edge_core_switch_vendor,
edge_cs.reachable AS edge_core_switch_reachable,
edge_fabric.seed_switch_wwn as edge_fabric_seed_switch_wwn,
edge_fabric.name AS edge_fabric_name,
edge_fabric.fabric_name AS edge_fabric_fabric_name,
edge_fabric.principal_switch_wwn AS edge_fabric_principal_switch_wwn,
edge_fabric.management_state AS edge_fabric_management_state,
CASE
WHEN bb_switch_port.trunk_master = 1 AND (edge_switch_port.trunk_master IS NULL
OR
edge_switch_port.trunk_master = 1) THEN 'IFL Trunk'
ELSE 'IFL'
END AS connection_type
FROM ifl
JOIN switch_port bb_switch_port ON ifl.bb_port_wwn = bb_switch_port.wwn
JOIN virtual_switch bb_vs ON bb_switch_port.virtual_switch_id = bb_vs.id
JOIN core_switch bb_cs ON bb_vs.core_switch_id = bb_cs.id
JOIN fabric_member ON fabric_member.virtual_switch_id = bb_vs.id
JOIN fabric bb_fabric ON bb_fabric.id = fabric_member.fabric_id
LEFT JOIN switch_port edge_switch_port ON ifl.edge_port_wwn =
edge_switch_port.wwn
LEFT JOIN virtual_switch edge_vs ON edge_switch_port.virtual_switch_id =
edge_vs.id
LEFT JOIN core_switch edge_cs ON edge_vs.core_switch_id = edge_cs.id
LEFT JOIN fabric_member fs ON fs.virtual_switch_id = edge_vs.id
LEFT JOIN fabric edge_fabric ON edge_fabric.id = fs.fabric_id