Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

ManualsBrandsHP ManualsSoftwareHP B-series SAN Network Advisor Software

1441

Brocade Network Advisor SAN User Manual 1397

53-1002696-01

Views

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,