Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1888)

1836 Brocade Network Advisor IP User Manual
53-1003153-01
Views
I
AND VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID;
VLAN_INT_CLASSIFIER_INFO
CREATE VIEW vlan_int_classifier_info AS
select VLAN_INTERFACE_RELATION.VLAN_INTERFACE_RELATION_ID,
VLAN_INTERFACE_RELATION.VLAN_DB_ID,
VLAN_INTERFACE_RELATION.INTERFACE_ID,
VLAN_INT_C_TAG_RELATION.C_TAG_ID,
MAC_GROUP.NAME,
MAC_GROUP.MAC_GROUP_ID,
MAC_GROUP.TYPE,
MAC_GROUP_MEMBER.MAC_ADDRESS,
MAC_GROUP_MEMBER.MASK,
MAC_GROUP.ID AS MAC_GROUP_DB_ID,
DEVICE.DEVICE_ID
from INTERFACE ,DEVICE ,PORT_VLAN
left outer join VLAN_INTERFACE_RELATION on
VLAN_INTERFACE_RELATION.VLAN_DB_ID = PORT_VLAN.VLAN_DB_ID
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,