Sflow_minute_mac_view – Brocade Network Advisor IP User Manual v12.1.0 User Manual

Page 1716

1662

Brocade Network Advisor IP User Manual

53-1002947-01

Views

from SFLOW_STAGING

LEFT JOIN VM_ADDRESS_INFO VM1 ON SFLOW_STAGING.L3_SRC_ADDR =

VM1.VM_ADDRESS

LEFT JOIN VM_ADDRESS_INFO VM2 ON SFLOW_STAGING.L3_DEST_ADDR =

VM2.VM_ADDRESS

where SFLOW_STAGING.SLNUM >= (( SELECT SFLOW_STAGING_SLNUM.MIN_SLNUM

FROM SFLOW_STAGING_SLNUM

LIMIT 1));

SFLOW_MINUTE_MAC_VIEW

create or replace view SFLOW_MINUTE_MAC_VIEW AS

select

SFLOW_MINUTE_MAC.DEVICE_ID,

SFLOW_MINUTE_MAC.TIME_IN_SECONDS,

SFLOW_MINUTE_MAC.SRC_MAC,

SFLOW_MINUTE_MAC.DEST_MAC,

SFLOW_MINUTE_MAC.IN_VLAN,

SFLOW_MINUTE_MAC.OUT_VLAN,

SFLOW_MINUTE_MAC.FRAMES,

SFLOW_MINUTE_MAC.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_MAC

LEFT JOIN VM_ADDRESS_INFO VM1 ON SFLOW_MINUTE_MAC.SRC_MAC = VM1.MAC_ADDRESS

LEFT JOIN VM_ADDRESS_INFO VM2 ON SFLOW_MINUTE_MAC.DEST_MAC = VM2.MAC_ADDRESS

WHERE SFLOW_MINUTE_MAC.SLNUM <= (( SELECT SFLOW_MINUTE_MAC_SLNUM.MAX_SLNUM

FROM SFLOW_MINUTE_MAC_SLNUM

LIMIT 1))

union all

select

SFLOW_STAGING.DEVICE_ID,

SFLOW_STAGING.TIME_IN_SECONDS,

SFLOW_STAGING.SRC_MAC,

SFLOW_STAGING.DEST_MAC,

SFLOW_STAGING.IN_VLAN,

SFLOW_STAGING.OUT_VLAN,

SFLOW_STAGING.FRAMES,

SFLOW_STAGING.BYTES,