Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1863)

Brocade Network Advisor IP User Manual 1811
53-1003153-01
Views
I
from DEVICE as TEMP_DEVICE
left join
(
select
FOUNDRY_DEVICE.DEVICE_ID,
FOUNDRY_DEVICE.PRODUCT_TYPE,
FOUNDRY_DEVICE.IMAGE_VERSION
from FOUNDRY_DEVICE
) TEMP_FOUNDRY_DEVICE on TEMP_DEVICE.DEVICE_ID = TEMP_FOUNDRY_DEVICE.DEVICE_ID
left join
(
select
PHYSICAL_DEVICE.DEVICE_ID,
PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID,
PHYSICAL_DEVICE.NUM_SLOTS,
PHYSICAL_DEVICE.UNIT_NUMBER
from PHYSICAL_DEVICE
) TEMP_PHYSICAL_DEVICE on TEMP_DEVICE.DEVICE_ID = TEMP_PHYSICAL_DEVICE.DEVICE_ID;
PORT_BOTTLENECK_CONF_INFO
This view provides combine port bottleneck configuration and enough information from switch port
for the client to identify the port.
create or replace view PORT_BOTTLENECK_CONF_INFO as
select
PORT_BOTTLENECK_CONFIG.SWITCH_PORT_ID,
PORT_BOTTLENECK_CONFIG.BOTTLENECK_DETECT_ENABLED,
PORT_BOTTLENECK_CONFIG.ALERTS_ENABLED,
PORT_BOTTLENECK_CONFIG.CONGESTION_THRESHOLD,
PORT_BOTTLENECK_CONFIG.LATENCY_THRESHOLD,
PORT_BOTTLENECK_CONFIG.WINDOW_,
PORT_BOTTLENECK_CONFIG.QUIET_TIME,
PORT_BOTTLENECK_CONFIG.CREATION_TIME,
PORT_BOTTLENECK_CONFIG.LAST_UPDATE_TIME,
PORT_BOTTLENECK_CONFIG.LATENCY_SEVERITY,
PORT_BOTTLENECK_CONFIG.LATENCY_TIME,
SWITCH_PORT.VIRTUAL_SWITCH_ID,
SWITCH_PORT.USER_PORT_NUMBER,
SWITCH_PORT.TYPE,
SWITCH_PORT.WWN
from
PORT_BOTTLENECK_CONFIG
left outer join SWITCH_PORT
on PORT_BOTTLENECK_CONFIG.SWITCH_PORT_ID = SWITCH_PORT.ID;
comment on view PORT_BOTTLENECK_CONF_INFO is
Combine port bottleneck configuration and enough info from switch port for the
client to identify the port.;
PORT_BOTTLENECK_STAT_INFO
This view provides combine port bottleneck status and enough information from the switch port for
the client to identify the port.
create or replace view PORT_BOTTLENECK_STAT_INFO as
select
PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID,