Brocade Communications Systems IP250 user manual Tempdevice.Firstseentime

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;

Brocade Network Advisor IP User Manual	1641
53-1003056-01