Brocade Communications Systems IP250 user manual Portvlaninfo, Protocolvlaninfo, Sflow

Views I

select

PORT_PROFILE_MAC_MAP.PROFILE_ID, PORT_PROFILE_MAC_MAP.MAC, PORT_PROFILE_MAC_MAP.NAME as MAC_NAME,

VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME, VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL, VM_VIRTUAL_MACHINE.NAME as VM_NAME, VM_VCENTER_MEMBER.HOST_NAME as HOST_NAME, VM_VCENTER.NAME as VCENTER_NAME,

INTERFACE.IDENTIFIER from

PORT_PROFILE_MAC_MAP

left outer join VM_VIRTUAL_ETHERNET_ADAPTER on PORT_PROFILE_MAC_MAP.MAC =

VM_VIRTUAL_ETHERNET_ADAPTER.MAC_ADDRESS left outer join VM_VIRTUAL_MACHINE on

VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.ID left outer join VM_VCENTER_MEMBER on VM_VIRTUAL_MACHINE.HOST_ID =

VM_VCENTER_MEMBER.VM_HOST_ID

left outer join VM_VCENTER on VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID left outer join L2_NEIGHBOR on PORT_PROFILE_MAC_MAP.MAC = encode(L2_NEIGHBOR.LLDP_REM_PORT_ID, 'base64')

left outer join INTERFACE on L2_NEIGHBOR.INTERFACE_ID = INTERFACE.INTERFACE_ID;

PORT_VLAN_INFO

create view PORT_VLAN_INFO as select

PV.*, DEVICE_ID, NAME,

TABLE_SUBTYPE

from

VLAN V,

PORT_VLAN PV where

V.VLAN_DB_ID = PV.VLAN_DB_ID;

PROTOCOL_VLAN_INFO

create or replace view PROTOCOL_VLAN_INFO as select

V.*,

port_vlan_db_id, is_dynamic, protocol

from vlan V, sub_port_vlan SPV, protocol_vlan PV

where V.vlan_db_id = SPV.vlan_db_id AND SPV.vlan_db_id = PV.vlan_db_id;

SFLOW

create or replace view SFLOW as

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