User's Manual

Brocade Network Advisor IP User Manual 1677
53-1003056-01
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;