HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 213
And Device_port_mac_address_map.mac_address = Gige_port.remote_mac_address
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 213 highlights
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 Brocade Network Advisor Documentation Updates 205 53-1002363-02