Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2670)

2598 Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Views
I
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;
SLOT_INFO
create or replace view SLOT_INFO as
select
SLOT.*,
PHYSICAL_DEVICE.UNIT_NUMBER,
DEVICE.IP_ADDRESS
from
PHYSICAL_DEVICE,
SLOT,
DEVICE
where
DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID
and SLOT.PHYSICAL_DEVICE_ID = PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID;