Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1551
53-1002948-01
Views
H
case
when TEMP_DEVICE.SUB_CATEGORY = 0 then (select distinct SWITCH_MODEL.MODEL
from SWITCH_MODEL where TEMP_DEVICE.SYS_OID = SWITCH_MODEL.SYS_OID)
else TEMP_DEVICE.BRIEF_PRODUCT_FAMILY
end as MODEL,
TEMP_FOUNDRY_DEVICE.IMAGE_VERSION as FIRMWARE,
TEMP_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID,
TEMP_PHYSICAL_DEVICE.NUM_SLOTS,
TEMP_PHYSICAL_DEVICE.UNIT_NUMBER,
TEMP_DEVICE.USER_DEFINED_VALUE_1,
TEMP_DEVICE.USER_DEFINED_VALUE_2,
TEMP_DEVICE.USER_DEFINED_VALUE_3
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