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

Brocade Network Advisor SAN + IP User Manual 2319
53-1002949-01
Views
I
where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_BGP_SLNUM fetch first 1 rows
only)
union all
select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN,
OUT_VLAN, FRAMES, BYTES
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only)
and SRC_AS != 0 OR SFLOW_IP_ROUTE_INFO_ID != 0;
-- Name: sflow_minute_l3_view; Type: VIEW; Schema: dcm; Owner: dcmadmin
create or replace view SFLOW_MINUTE_L3_VIEW as
select DEVICE_ID, TIME_IN_SECONDS, L3_SRC_ADDR, L3_DEST_ADDR, L3_PROTOCOL,
L4_PROTOCOL, TCP_FLAGS, IN_VLAN, OUT_VLAN, FRAMES, BYTES
from SFLOW_MINUTE_L3
where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_L3_SLNUM fetch first 1 rows
only)
union all
select DEVICE_ID, TIME_IN_SECONDS, L3_SRC_ADDR, L3_DEST_ADDR, L3_PROTOCOL,
L4_PROTOCOL, TCP_FLAGS, IN_VLAN, OUT_VLAN, FRAMES, BYTES
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
-- Name: sflow_minute_mac_view; Type: VIEW; Schema: dcm; Owner: dcmadmin
create or replace view SFLOW_MINUTE_MAC_VIEW as
select DEVICE_ID, TIME_IN_SECONDS, SRC_MAC, DEST_MAC, IN_VLAN, OUT_VLAN, FRAMES,
BYTES
from SFLOW_MINUTE_MAC
where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_MAC_SLNUM fetch first 1 rows
only)
union all
select DEVICE_ID, TIME_IN_SECONDS, SRC_MAC, DEST_MAC, IN_VLAN, OUT_VLAN, FRAMES,
BYTES
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
-- Name: sflow_minute_vlan_view; Type: VIEW; Schema: dcm; Owner: dcmadmin
create or replace view SFLOW_MINUTE_VLAN_VIEW as
select DEVICE_ID, TIME_IN_SECONDS, IN_VLAN, OUT_VLAN, FRAMES, BYTES
from SFLOW_MINUTE_VLAN
where SLNUM <= (select MAX_SLNUM from SFLOW_MINUTE_VLAN_SLNUM fetch first 1 rows
only)
union all
select DEVICE_ID, TIME_IN_SECONDS, IN_VLAN, OUT_VLAN, FRAMES, BYTES
from SFLOW_STAGING
where SLNUM >= (select MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows
only);
create view PORT_VLAN_INFO as
select
PV.*,
DEVICE_ID,
NAME,
TABLE_SUBTYPE
from
VLAN V,
PORT_VLAN PV
where