Brocade Communications Systems IP250 Vmvnetworkinfo, Device PHYSICALINTERFACE, Physicalport

Views I

SELECT de.device_id, de.ip_address AS device_ip, se.target_type, sp.id AS target_id, sp.name AS target_name, 1 AS collectible_type, se.expression_id AS collectible_id, se.collector_id, ( SELECT perf_collector.name AS collector_name

FROM perf_collector

WHERE perf_collector.collector_id = se.collector_id) AS collector_name, ( SELECT snmp_expression.name AS collectible_name

FROM snmp_expression

WHERE snmp_expression.expression_id = se.expression_id) AS collectible_name, ( SELECT snmp_expression.equation AS collectible_detail

FROM snmp_expression

WHERE snmp_expression.expression_id = se.expression_id) AS collectible_detail, se.value, se.time_in_seconds, '' AS mib_index

FROM snmp_expr_data_info se

JOIN switch_port sp ON se.target_type = 4 AND se.target_id = sp.id JOIN device de ON (( SELECT sw.managed_element_id

FROM virtual_switch sw

WHERE sw.id = sp.virtual_switch_id)) = de.managed_element_id;

VM_VNETWORK_INFO

This view provideds combine VM and device information to derive VM to the ingress switch port information.

create or replace view VM_VNETWORK_INFO as select

VM_HOST.HYPERVISOR_NAME as VHOST_NAME, VM_VIRTUAL_MACHINE.NAME as VM_NAME, VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID as VM_ID, VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS as VNIC_MAC, VM_DV_PORT_GROUP.NAME as PGRP_NAME, VM_DV_SWITCH.NAME as VSWITCH_NAME, VNIC_DV_PORT.NAME as DVPORT_NAME, VM_PHYSICAL_NIC.DEVICE_NAME as PNIC_NAME, VM_PHYSICAL_NIC.MAC_ADDRESS as PNIC_MAC, DEVICE.SYS_NAME as SWITCH_NAME, DEVICE.IP_ADDRESS as SWITCH_IP, PHYSICAL_PORT.PORT_NUM as SWITCH_PORT, INTERFACE.PORT_STATUS as SWITCH_PORT_STATUS

from

VM_HOST

left join VM_VIRTUAL_MACHINE on VM_HOST.DEVICE_ENCLOSURE_ID =

VM_VIRTUAL_MACHINE.HOST_ID, VM_VIRTUAL_ETHERNET_ADAPTER, VM_DV_PORT VNIC_DV_PORT, VM_DV_PORT PNIC_DV_PORT, VM_DV_PORT_GROUP, VM_DV_SWITCH, VM_PHYSICAL_NIC, VM_HOST_END_DEV_CONNECTIVITY, INTERFACE,

DEVICE,

PHYSICAL_INTERFACE, PHYSICAL_PORT

where

VM_VIRTUAL_MACHINE.ID = VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID and VM_VIRTUAL_ETHERNET_ADAPTER.VM_DV_PORT_ID is not null and VM_VIRTUAL_ETHERNET_ADAPTER.VM_DV_PORT_ID = VNIC_DV_PORT.ID and VNIC_DV_PORT.VM_DV_PORT_GROUP_ID = VM_DV_PORT_GROUP.ID and VNIC_DV_PORT.VM_DV_SWITCH_ID = VM_DV_SWITCH.ID and

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