Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2325)

2288 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
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,
sflow_staging.out_priority, sflow_staging.in_vlan, sflow_staging.out_vlan,
sflow_staging.l3_protocol, sflow_staging.l4_src_port, sflow_staging.l4_dest_port,
sflow_staging.time_in_seconds, sflow_staging.src_mac, sflow_staging.dest_mac,
sflow_staging.l3_src_addr, sflow_staging.l3_dest_addr, sflow_staging.tcp_flags,
sflow_staging.local_as, sflow_staging.src_as, sflow_staging.src_peer_as,
sflow_staging.sflow_ip_route_info_id, sflow_staging.ip_flow_label,
sflow_staging.src_user, sflow_staging.dest_user, sflow_staging.frames,
sflow_staging.bytes, sflow_staging.in_unit, sflow_staging.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_staging
LEFT JOIN vm_address_info vm1 ON sflow_staging.src_mac = vm1.mac_address