Brocade Communications Systems IP250 Sflowminutebgpview, Sflowminutevlanview, Physicaldeviceinfo

Views I

SFLOW_MINUTE_BGP_VIEW

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 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;

SFLOW_MINUTE_VLAN_VIEW

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);

PHYSICAL_DEVICE_INFO

create or replace view PHYSICAL_DEVICE_INFO as select

PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID as PD_PHYSICAL_DEVICE_ID,

PHYSICAL_DEVICE.DEVICE_ID, PHYSICAL_DEVICE.DESCRIPTION, PHYSICAL_DEVICE.NUM_SLOTS, PHYSICAL_DEVICE.TABLE_SUBTYPE, PHYSICAL_DEVICE.UNIT_NUMBER, PHYSICAL_DEVICE.UNIT_NEIGHBOR1, PHYSICAL_DEVICE.UNIT_NEIGHBOR2, PHYSICAL_DEVICE.UNIT_PRESENT,

FOUNDRY_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID as FPD_PHYSICAL_DEVICE_ID,

FOUNDRY_PHYSICAL_DEVICE.SERIAL_NUMBER,

FOUNDRY_PHYSICAL_DEVICE.PRODUCT_TYPE, DEVICE.IP_ADDRESS

from

PHYSICAL_DEVICE,

FOUNDRY_PHYSICAL_DEVICE, DEVICE

where

DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID and PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID =

FOUNDRY_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID;

Brocade Network Advisor IP User Manual	1677
53-1003056-01