Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1445 / 1505

Brocade Network Advisor SAN User Manual 1397
53-1002696-01
Views
H
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,
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_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