HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 256
Select Device_id, Time_in_seconds, Src_as, Sflow_ip_route_info_id, In_vlan, L3_src_addr, L3_dest_addr
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 256 highlights
E Views -- Name: sflow_minute_bgp_view; Type: VIEW; Schema: dcm; Owner: dcmadmin create or replace view SFLOW_MINUTE_BGP_VIEW as select DEVICE_ID, TIME_IN_SECONDS, SRC_AS, SFLOW_IP_ROUTE_INFO_ID, IN_VLAN, OUT_VLAN, FRAMES, BYTES from SFLOW_MINUTE_BGP 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; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: create table SFLOW_MINUTE_L3 ( SLNUM bigserial not null, DEVICE_ID integer not null, TIME_IN_SECONDS integer not null, L3_PROTOCOL integer not null, L3_SRC_ADDR bytea, L3_DEST_ADDR bytea, L4_PROTOCOL smallint, FRAMES bigint not null, BYTES bigint not null, IN_VLAN smallint, OUT_VLAN smallint, TCP_FLAGS smallint ); -- Name: sflow_minute_l3_pk; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: create table SFLOW_MINUTE_L3_SLNUM ( MAX_SLNUM bigint ) with (autovacuum_vacuum_threshold=4); -- 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 MIN_SLNUM from SFLOW_STAGING_SLNUM fetch first 1 rows only); -- Name: sflow_minute_mac; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace: create table SFLOW_MINUTE_MAC ( SLNUM bigserial not null, TIME_IN_SECONDS integer not null, DEVICE_ID integer not null, FRAMES bigint not null, BYTES bigint not null, 248 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/256.png)