Brocade Network Advisor IP User Manual 1641
53-1003056-01
Views I
when TEMP_DEVICE.CATEGORY = 2 then 'CHASSIS'
when TEMP_DEVICE.CATEGORY = 3 then 'STACK'
when TEMP_DEVICE.CATEGORY = 4 then 'ACCESS POINT'
when TEMP_DEVICE.CATEGORY = 5 then 'WIRELESS CONTROLLER'
else 'UNKNOWN'
end as CATEGORY_TXT,
TEMP_DEVICE.SUB_CATEGORY,
case
when TEMP_DEVICE.SUB_CATEGORY = 1 then 'DCB 8000'
when TEMP_DEVICE.SUB_CATEGORY = 2 then 'DCB 8470'
when TEMP_DEVICE.SUB_CATEGORY = 3 then 'DCB M8428'
when TEMP_DEVICE.SUB_CATEGORY = 4 then 'DCX'
when TEMP_DEVICE.SUB_CATEGORY = 5 then 'DCX-4S'
when TEMP_DEVICE.SUB_CATEGORY = 6 then 'VCS/VDX'
when TEMP_DEVICE.SUB_CATEGORY = 7 then 'VDX 6720-24'
when TEMP_DEVICE.SUB_CATEGORY = 8 then 'VDX 6720-60'
when TEMP_DEVICE.SUB_CATEGORY = 9 then 'VDX 6710'
when TEMP_DEVICE.SUB_CATEGORY = 10 then 'VDX 6730-24'
when TEMP_DEVICE.SUB_CATEGORY = 11 then 'VDX 6730-60'
when TEMP_DEVICE.SUB_CATEGORY = 12 then 'VDX 8770-4'
when TEMP_DEVICE.SUB_CATEGORY = 13 then 'VDX 8770-8'
when TEMP_DEVICE.SUB_CATEGORY = 14 then 'VDX 8770-16'
when TEMP_DEVICE.SUB_CATEGORY = 15 then 'VDX 2730'
else 'IP DEVICE'
end as SUB_CATEGORY_TXT,
TEMP_DEVICE.FIRST_SEEN_TIME,
TO_TIMESTAMP(TEMP_DEVICE.FIRST_SEEN_TIME,'YYYYMMDDHH24MISS') as
FIRST_SEEN_TIMESTAMP,
TEMP_DEVICE.PORT_COUNT,
TEMP_DEVICE.LICENSE_PORT_COUNT,
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;