Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1645)

1598 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
AND VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID;
VM_CONNECTIVITY_INFO
This view combines fabric and VM information to derive end to end connectivity information for the
VM.
create or replace view VM_CONNECTIVITY_INFO as
select
VM_VCENTER.HOST AS VCENTER_HOST,
DEVICE_PORT.SWITCH_PORT_WWN,
DEVICE_PORT.DOMAIN_ID,
device_port.id as device_port_id,
DEVICE_PORT.NUMBER,
CORE_SWITCH.IP_ADDRESS,
CORE_SWITCH.NAME AS CORE_NAME,
VM_VCENTER.ID AS VCENTER_ID,
DEVICE_ENCLOSURE.ID AS HOST_DB_ID,
DEVICE_ENCLOSURE.IP_ADDRESS AS HYPERVISOR_HOST,
VM_VIRTUAL_MACHINE.ID as VM_ID,
VM_VIRTUAL_MACHINE.IP_ADDRESS AS VM_IP_ADDRESS,
VM_VIRTUAL_MACHINE.HOSTNAME AS VM_HOST_NAME,
VM_VIRTUAL_MACHINE.UUID AS VM_UUID,
VM_VIRTUAL_MACHINE.NAME AS VM_NAME,
VM_PATH.NAME AS PATH_NAME,
VM_PATH.HBA_PORT AS ADAPTER_PORT_WWN,
VM_PATH.TARGET_PORT AS TARGET_PORT_WWN,
VM_STORAGE.NAME AS LUN_CAN_NAME,
VM_PATH.FS_TYPE,
VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID,
DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID AS HOST_ME_ID,
DEVICE_ENCLOSURE.IP_ADDRESS AS HOST_IP_ADDRESS,
DEVICE_ENCLOSURE.HOST_NAME AS HYPERVISOR_HOST_NAME,
FABRIC.NAME AS FABRIC_NAME,
VIRTUAL_SWITCH.NAME AS VIRTUAL_NAME,
SWITCH_PORT.STATUS AS SWITCH_PORT_STATUS,
SWITCH_PORT.ID as SWITCH_PORT_ID,
SWITCH_PORT.PORT_ID,
SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.SLOT_NUMBER,
USER_DEFINED_DEVICE_DETAIL.NAME AS ADAPTER_PORT_NAME,
VM_PATH.FABRIC_ID,
VM_PATH.VM_PORT_WWN,
VM_STORAGE.MODEL,
VM_STORAGE.VENDOR
from
DEVICE_PORT
left join USER_DEFINED_DEVICE_DETAIL
on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN,
CORE_SWITCH,
SWITCH_PORT,
VIRTUAL_SWITCH,
DEVICE_NODE,
FABRIC,
VM_STORAGE,
VM_PATH,
DEVICE_ENCLOSURE,
VM_VIRTUAL_MACHINE,
VM_VCENTER,