Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1223
53-1002167-01
Views
E
IN_VLAN smallint,
OUT_VLAN smallint,
SRC_MAC bytea,
DEST_MAC bytea
);
create table SFLOW_MINUTE_MAC_SLNUM (
MAX_SLNUM bigint
) with (autovacuum_vacuum_threshold=4);
-- 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_summary; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
create table SFLOW_MINUTE_SUMMARY
(
SLNUM bigserial not null,
TIME_IN_SECONDS integer not null,
DEVICE_ID integer not null,
FRAMES bigint not null,
BYTES bigint not null
);
-- Name: sflow_minute_vlan; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
create table SFLOW_MINUTE_VLAN
(
SLNUM bigserial not null,
TIME_IN_SECONDS integer not null,
DEVICE_ID integer not null,
FRAMES bigint not null,
BYTES bigint not null,
IN_VLAN smallint,
OUT_VLAN smallint
);
create table SFLOW_MINUTE_VLAN_SLNUM (
MAX_SLNUM bigint
) with (autovacuum_vacuum_threshold=4);
-- 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