User's Manual

Brocade Network Advisor IP User Manual 1661
53-1003056-01
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