Sflow_minute_l3_view – Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2326

Brocade Network Advisor SAN + IP User Manual

2289

53-1002949-01

Views

LEFT JOIN vm_address_info vm3 ON sflow_staging.l3_src_addr = vm3.vm_address

LEFT JOIN vm_address_info vm2 ON sflow_staging.dest_mac = vm2.mac_address

LEFT JOIN vm_address_info vm4 ON sflow_staging.l3_dest_addr = vm4.vm_address

WHERE sflow_staging.slnum >= (( SELECT sflow_staging_slnum.min_slnum

FROM sflow_staging_slnum LIMIT 1));

SFLOW_MINUTE_L3_VIEW

create or replace view SFLOW_MINUTE_L3_VIEW AS

select

SFLOW_MINUTE_L3.DEVICE_ID,

SFLOW_MINUTE_L3.TIME_IN_SECONDS,

SFLOW_MINUTE_L3.L3_SRC_ADDR,

SFLOW_MINUTE_L3.L3_DEST_ADDR,

SFLOW_MINUTE_L3.L3_PROTOCOL,

SFLOW_MINUTE_L3.L4_PROTOCOL,

SFLOW_MINUTE_L3.TCP_FLAGS,

SFLOW_MINUTE_L3.IN_VLAN,

SFLOW_MINUTE_L3.OUT_VLAN,

SFLOW_MINUTE_L3.FRAMES,

SFLOW_MINUTE_L3.BYTES,

VM1.VM_NAME AS SRC_VM_NAME,

VM2.VM_NAME AS DEST_VM_NAME,

VM1.VM_ADDRESS AS SRC_VM_ADDRESS,

VM2.VM_ADDRESS AS DEST_VM_ADDRESS,

VM1.VM_HOST_NAME AS SRC_VM_HOST_NAME,

VM2.VM_HOST_NAME AS DEST_VM_HOST_NAME,

VM1.VM_HOST_ADDRESS AS SRC_VM_HOST_ADDRESS,

VM2.VM_HOST_ADDRESS AS DEST_VM_HOST_ADDRESS,

VM1.VM_ID AS SRC_VM_ID,

VM2.VM_ID AS DEST_VM_ID,

VM1.VM_HOST_ID AS SRC_VM_HOST_ID,

VM2.VM_HOST_ID AS DEST_VM_HOST_ID

from

SFLOW_MINUTE_L3

LEFT JOIN VM_ADDRESS_INFO VM1 ON SFLOW_MINUTE_L3.L3_SRC_ADDR = VM1.VM_ADDRESS

LEFT JOIN VM_ADDRESS_INFO VM2 ON SFLOW_MINUTE_L3.L3_DEST_ADDR = VM2.VM_ADDRESS

where

SFLOW_MINUTE_L3.SLNUM <= (( SELECT SFLOW_MINUTE_L3_SLNUM.MAX_SLNUM

FROM SFLOW_MINUTE_L3_SLNUM

LIMIT 1))

union all

select SFLOW_STAGING.DEVICE_ID, SFLOW_STAGING.TIME_IN_SECONDS,

SFLOW_STAGING.L3_SRC_ADDR, SFLOW_STAGING.L3_DEST_ADDR, SFLOW_STAGING.L3_PROTOCOL,

SFLOW_STAGING.L4_PROTOCOL, SFLOW_STAGING.TCP_FLAGS, SFLOW_STAGING.IN_VLAN,

SFLOW_STAGING.OUT_VLAN, SFLOW_STAGING.FRAMES, SFLOW_STAGING.BYTES,