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

2290 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
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,
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,