Brocade Communications Systems IP250 Vmaddressinfo, Vlanintclassifierinfo, Device.Deviceid

Views I

left outer join VIRTUAL_SWITCH VS2

on VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN = VS2.WWN left outer join CORE_SWITCH CS1

on VS1.CORE_SWITCH_ID = CS1.ID left outer join CORE_SWITCH CS2

on VS2.CORE_SWITCH_ID = CS2.ID left outer join SWITCH_PORT SP1

on (SP1.VIRTUAL_SWITCH_ID=VS1.ID

and VIRTUAL_PORT_WWN_DETAILS.SLOT_NUMBER = SP1.SLOT_NUMBER

and VIRTUAL_PORT_WWN_DETAILS.SWITCH_PORT_NUMBER = SP1.PORT_NUMBER and SP1.TYPE NOT IN ('GigE-Port','TE-Port'))

left outer join SWITCH_PORT SP2

on (SP2.VIRTUAL_SWITCH_ID=VS2.ID

and VIRTUAL_PORT_WWN_DETAILS.AG_PORT_NUMBER = SP2.PORT_NUMBER and SP2.TYPE NOT IN ('GigE-Port','TE-Port'))

left outer join USER_DEFINED_DEVICE_DETAIL UDDD

on VIRTUAL_PORT_WWN_DETAILS.AG_NODE_WWN = UDDD.WWN;

VM_ADDRESS_INFO

create or replace view VM_ADDRESS_INFO AS select

DECODE(VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS::TEXT, 'HEX'::TEXT) AS MAC_ADDRESS,

VM_VIRTUAL_MACHINE.NAME AS VM_NAME,

DECODE(VM_VIRTUAL_MACHINE.IP_ADDRESS::TEXT, 'HEX'::TEXT) AS VM_ADDRESS, VM_VCENTER_MEMBER.HOST_NAME AS VM_HOST_NAME, DECODE(VM_VIRTUAL_MACHINE.IP_ADDRESS::TEXT, 'HEX'::TEXT) AS VM_HOST_ADDRESS, VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID AS VM_ID, VM_VIRTUAL_MACHINE.HOST_ID AS VM_HOST_ID

FROM

VM_VIRTUAL_MACHINE,

VM_VIRTUAL_ETHERNET_ADAPTER,

VM_VCENTER_MEMBER

WHERE

VM_VIRTUAL_MACHINE.ID = VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID 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

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