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

1814 Brocade Network Advisor IP User Manual
53-1003153-01
Views
I
PORT_PROFILE.FCOE_PROFILE,
PORT_PROFILE.VLAN_PROFILE,
PORT_PROFILE.VLAN_DETAILS,
PORT_PROFILE.DEFAULT_PROFILE,
PORT_PROFILE.ACL_NAME,
PORT_PROFILE.FCOE_MAP_NAME,
PORT_PROFILE_INTERFACE_MAP.INTERFACE_ID,
PORT_PROFILE_INTERFACE_MAP.SWITCH_PORT_ID
from
PORT_PROFILE,
PORT_PROFILE_INTERFACE_MAP
where
PORT_PROFILE.ID= PORT_PROFILE_INTERFACE_MAP.PROFILE_ID;
PORT_PROFILE_MAC_INFO
create or replace view PORT_PROFILE_MAC_INFO as
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;