HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 212
Vm_connectivity_info, Views
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 212 highlights
E Views VIRTUAL_FCOE_PORT.PORT_TYPE, VIRTUAL_FCOE_PORT.ENABLED, VIRTUAL_FCOE_PORT.STATUS, VIRTUAL_FCOE_PORT.TRUNK_INDEX, VIRTUAL_FCOE_PORT.PORT_NUMBER, VIRTUAL_FCOE_PORT.NAME, VIRTUAL_FCOE_PORT.SLOT_NUMBER, VIRTUAL_FCOE_PORT.VLAN_ID, VIRTUAL_FCOE_PORT.DEVICE_COUNT, VIRTUAL_FCOE_PORT.PEER_MAC, VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN, VIRTUAL_SWITCH.ROLE as SWITCH_ROLE, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID, VIRTUAL_SWITCH.DOMAIN_ID as DOMAIN_ID, VIRTUAL_SWITCH.INTEROP_MODE as INTEROP_MODE, CORE_SWITCH.TYPE as SWITCH_TYPE, CORE_SWITCH.FIRMWARE_VERSION as FIRMWARE_VERSION, CORE_SWITCH.IP_ADDRESS as IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, CORE_SWITCH.MODEL as SWITCH_MODEL, CORE_SWITCH_DETAILS.MODEL_NUMBER as SWITCH_MODEL_NUMBER from VIRTUAL_FCOE_PORT, CORE_SWITCH, VIRTUAL_SWITCH, CORE_SWITCH_DETAILS where VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID; VM_CONNECTIVITY_INFO This view provides combine fabric and VM information to derive end to end connectivity information for the VM. create or replace view VM_CONNECTIVITY_INFO as 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 204 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/212.png)