Brocade Communications Systems IP250 user manual Vmconnectivityinfo, Macgroup.Id

I Views

left outer join VLAN_INT_MAC_GROUP_RELATION TEMP_MAC_RELATION on

VLAN_INTERFACE_RELATION.VLAN_INTERFACE_RELATION_ID = TEMP_MAC_RELATION.VLAN_INTERFACE_RELATION_ID

left outer join VLAN_INT_C_TAG_RELATION on

VLAN_INT_C_TAG_RELATION.VLAN_INTERFACE_RELATION_ID = VLAN_INTERFACE_RELATION.VLAN_INTERFACE_RELATION_ID

left outer join MAC_GROUP on TEMP_MAC_RELATION.MAC_GROUP_DB_ID =

MAC_GROUP.ID

left outer join MAC_GROUP_MEMBER on MAC_GROUP_MEMBER.MAC_GROUP_DB_ID =

MAC_GROUP.ID

left outer join DEVICE_MAC_GROUP_MAPPING on

DEVICE_MAC_GROUP_MAPPING.MAC_GROUP_DB_ID = MAC_GROUP.ID

where VLAN_INTERFACE_RELATION.INTERFACE_ID = INTERFACE.INTERFACE_ID and

INTERFACE.DEVICE_ID = DEVICE.DEVICE_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

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