Brocade Communications Systems IP250 user manual Vmnetworkconnectivityinfo

I Views

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,

DEVICE_PORT_MAC_ADDRESS_MAP, GIGE_PORT,

VM_STORAGE, VM_PATH,

DEVICE_ENCLOSURE, VM_VIRTUAL_MACHINE, VM_VCENTER, VM_DATA_CENTER, VM_HOST

where

VM_PATH.HBA_PORT = DEVICE_PORT.WWN

and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID and VM_PATH.STORAGE_ID = VM_STORAGE.ID

and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID

and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID and VM_HOST.VM_DATACENTER_ID = VM_DATA_CENTER.ID

and VM_DATA_CENTER.VCENTER_ID = VM_VCENTER.ID

and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS::TEXT =

GIGE_PORT.REMOTE_MAC_ADDRESS::TEXT

and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID

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;

comment on view VM_CONNECTIVITY_INFO is

'Combine fabric and VM info to derive end to end connectivity information for the VM';

VM_NETWORK_CONNECTIVITY_INFO

CREATE VIEW vm_network_connectivity_info AS

select VM_VIRTUAL_ETHERNET_ADAPTER.ID as VNIC_ID, VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS,VM_VIRTUAL_ETHERNET_ADAPTER.IP_ADDRESS as

VM_IP_ADDRESS, VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL,

VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME, VM_VIRTUAL_MACHINE.ID as VM_ID, VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME, VM_VIRTUAL_MACHINE.HOST_ID as HOST_ID, VM_VCENTER_MEMBER.HOST_NAME,

1664	Brocade Network Advisor IP User Manual
	53-1003056-01