Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1868)

1816 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
case
when TEMP_DEVICE.SUB_CATEGORY > 0 then (select distinct VCSD.IP_ADDRESS from
DEVICE as VCSD where VCSD.MANAGED_ELEMENT_ID
in (select distinct VM.CLUSTER_ME_ID from VCS_CLUSTER_MEMBER as VM where
TEMP_DEVICE.MANAGED_ELEMENT_ID = VM.MEMBER_ME_ID))
else null
end as VCS_IP_ADDRESS,
TEMP_DEVICE.SYS_CONTACT,
TEMP_DEVICE.SYS_LOCATION,
TEMP_DEVICE.DESCRIPTION,
TEMP_DEVICE.LAST_SEEN_TIME,
TO_TIMESTAMP(TEMP_DEVICE.LAST_SEEN_TIME,'YYYYMMDDHH24MISS') as
LAST_SEEN_TIMESTAMP,
TEMP_DEVICE.VendOR,
TEMP_DEVICE.CATEGORY,
case
when TEMP_DEVICE.CATEGORY = 1 then 'FIXED CONFIGURATION'
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