HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 257
Select Device_id, Time_in_seconds, Src_mac, Dest_mac, In_vlan, Out_vlan, Frames, Bytes
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 257 highlights
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 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