Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1179
53-1002167-01
Views
E
from
DEVICE_PORT
left outer join USER_DEFINED_DEVICE_DETAIL
on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN,
CORE_SWITCH,
SWITCH_PORT,
VIRTUAL_SWITCH,
VM_CONNECTIVITY,
DEVICE_NODE,
FABRIC
where
VM_CONNECTIVITY.ADAPTER_PORT_WWN = DEVICE_PORT.WWN
and DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN
and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID
and DEVICE_NODE.FABRIC_ID = FABRIC.ID
union all
select
DEVICE_PORT.SWITCH_PORT_WWN,
DEVICE_PORT.DOMAIN_ID,
DEVICE_PORT.NUMBER,
CORE_SWITCH.IP_ADDRESS,
CORE_SWITCH.NAME AS CORE_NAME,
VM_CONNECTIVITY.ID,
VM_CONNECTIVITY.VCENTER_ID,
VM_CONNECTIVITY.HYPERVISOR_HOST,
VM_CONNECTIVITY.VM_NAME,
VM_CONNECTIVITY.PATH_NAME,
VM_CONNECTIVITY.ADAPTER_PORT_WWN,
VM_CONNECTIVITY.TARGET_PORT_WWN,
VM_CONNECTIVITY.LUN_CAN_NAME,
VM_CONNECTIVITY.ADAPTER_PORT_STATUS,
VM_CONNECTIVITY.FS_TYPE,
VM_CONNECTIVITY.HYPERVISOR_VM_ID,
VM_CONNECTIVITY.ADAPTER_PORT_TYPE,
FABRIC.NAME AS FABRIC_NAME,
VIRTUAL_SWITCH.NAME AS VIRTUAL_NAME,
SWITCH_PORT.STATUS AS SWITCH_PORT_STATUS,
SWITCH_PORT.PORT_ID,
SWITCH_PORT.PORT_NUMBER,
USER_DEFINED_DEVICE_DETAIL.NAME AS ADAPTER_PORT_NAME,
VM_CONNECTIVITY.FABRIC_ID
from
DEVICE_PORT
left join USER_DEFINED_DEVICE_DETAIL
on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN,
CORE_SWITCH,
SWITCH_PORT,
VIRTUAL_SWITCH,
VM_CONNECTIVITY,
DEVICE_NODE,
FABRIC,
DEVICE_PORT_MAC_ADDRESS_MAP,
GIGE_PORT
where
VM_CONNECTIVITY.ADAPTER_PORT_WWN = DEVICE_PORT.WWN
and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID
and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS = GIGE_PORT.REMOTE_MAC_ADDRESS
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID