Brocade Communications Systems Network Advisor 12.0.0, Руководство пользователя

Страница: 1443 / 1505

Brocade Network Advisor SAN User Manual 1395
53-1002696-01
Views
H
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;
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,
sflow_hour_summary.out_priority, sflow_hour_summary.in_vlan,
sflow_hour_summary.out_vlan, sflow_hour_summary.l3_protocol,
sflow_hour_summary.l4_src_port, sflow_hour_summary.l4_dest_port,
sflow_hour_summary.time_in_seconds, sflow_hour_summary.src_mac,
sflow_hour_summary.dest_mac, sflow_hour_summary.l3_src_addr,
sflow_hour_summary.l3_dest_addr, sflow_hour_summary.tcp_flags,
sflow_hour_summary.local_as, sflow_hour_summary.src_as,
sflow_hour_summary.src_peer_as, sflow_hour_summary.sflow_ip_route_info_id,
sflow_hour_summary.ip_flow_label, sflow_hour_summary.src_user,
sflow_hour_summary.dest_user, sflow_hour_summary.frames,
sflow_hour_summary.bytes, sflow_hour_summary.in_unit,
sflow_hour_summary.out_unit, COALESCE(vm1.vm_name, vm3.vm_name) AS src_vm_name,
COALESCE(vm2.vm_name, vm4.vm_name) AS dest_vm_name, COALESCE(vm1.vm_address,
vm3.vm_address) AS src_vm_address, COALESCE(vm2.vm_address, vm4.vm_address) AS
dest_vm_address, COALESCE(vm1.vm_host_name, vm3.vm_host_name) AS
src_vm_host_name, COALESCE(vm2.vm_host_name, vm4.vm_host_name) AS
dest_vm_host_name, COALESCE(vm1.vm_host_address, vm3.vm_host_address) AS
src_vm_host_address, COALESCE(vm2.vm_host_address, vm4.vm_host_address) AS
dest_vm_host_address, COALESCE(vm1.vm_id, vm3.vm_id) AS src_vm_id,
COALESCE(vm2.vm_id, vm4.vm_id) AS dest_vm_id,
COALESCE(vm1.vm_host_id, vm3.vm_host_id) AS src_vm_host_id,
COALESCE(vm2.vm_host_id, vm4.vm_host_id) AS dest_vm_host_id
FROM sflow_hour_summary
LEFT JOIN vm_address_info vm1 ON sflow_hour_summary.src_mac = vm1.mac_address
LEFT JOIN vm_address_info vm3 ON sflow_hour_summary.l3_src_addr =
vm3.vm_address
LEFT JOIN vm_address_info vm2 ON sflow_hour_summary.dest_mac = vm2.mac_address
LEFT JOIN vm_address_info vm4 ON sflow_hour_summary.l3_dest_addr =
vm4.vm_address
WHERE sflow_hour_summary.slnum <= (( SELECT sflow_hour_summary_slnum.max_slnum
FROM sflow_hour_summary_slnum LIMIT 1))
UNION ALL
SELECT sflow_staging.device_id, sflow_staging.in_slot,
sflow_staging.in_port, sflow_staging.out_slot, sflow_staging.out_port,
sflow_staging.l4_protocol, sflow_staging.ip_tos, sflow_staging.src_subnet_bits,
sflow_staging.dest_subnet_bits, sflow_staging.in_priority,