Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1626)

Brocade Network Advisor SAN User Manual 1579
53-1002948-01
Views
H
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
TEMP_PORT_VLAN.VLAN_DB_ID,
TEMP_PORT_VLAN.STP,
TEMP_PORT_VLAN.VLAN_ID,
TEMP_PORT_VLAN.QOS,
TEMP_PORT_VLAN.GLOBAL_VLAN_DB_ID,
TEMP_PORT_VLAN.STP_INSTANCE_ID,
TEMP_PORT_VLAN.ADMIN_STATUS,
TEMP_PORT_VLAN.FCOE_ENABLED,
TEMP_PORT_VLAN.TVF,
TEMP_PORT_VLAN.PVLAN_TYPE,
TEMP_PORT_VLAN.PRIMARY_VLAN_ID,
TEMP_VLAN.DEVICE_ID,
TEMP_VLAN.NAME,
TEMP_VLAN.TABLE_SUBTYPE
from
VLAN TEMP_VLAN,
PORT_VLAN TEMP_PORT_VLAN
where
TEMP_VLAN.VLAN_DB_ID = TEMP_PORT_VLAN.VLAN_DB_ID;
SFLOW
create or replace view SFLOW as
select
sflow_hour_summary.device_id, sflow_hour_summary.in_slot,
sflow_hour_summary.in_port, sflow_hour_summary.out_slot,
sflow_hour_summary.out_port, sflow_hour_summary.l4_protocol,
sflow_hour_summary.ip_tos, sflow_hour_summary.src_subnet_bits,
sflow_hour_summary.dest_subnet_bits, sflow_hour_summary.in_priority,