Brocade Communications Systems IP250 user manual Tempdevice.Fabricwatchstatus, Lastseentimestamp

I Views

end)

when TEMP_DEVICE.OPER_STATUS = 2 then 'NOT REACHABLE' when TEMP_DEVICE.OPER_STATUS = 3 then 'DEGRADED' when TEMP_DEVICE.OPER_STATUS = 4 then 'MARGINAL' when TEMP_DEVICE.OPER_STATUS = 5 then 'DOWN'

else 'UNKNOWN'

end as OPER_STATUS_TXT,

TEMP_DEVICE.FABRIC_WATCH_STATUS,

TEMP_DEVICE.FABRIC_WATCH_STATUS_REASON, TEMP_DEVICE.ADMIN_STATUS,

case

when TEMP_DEVICE.ADMIN_STATUS = 1 then 'TROUBLESHOOTING' else 'NORMAL'

end as ADMIN_STATUS_TXT,

TEMP_DEVICE.ADMIN_STATUS_LAST_UPDATED, TEMP_DEVICE.MEMO, TEMP_DEVICE.MEMO_LAST_UPDATED, TEMP_DEVICE.SYS_OID,

TEMP_DEVICE.RBRIDGE_ID,

TEMP_DEVICE.IP_ADDRESS,

TEMP_FOUNDRY_DEVICE.PRODUCT_TYPE, case

when TEMP_DEVICE.IS_ROUTER = 1 then 'ROUTER' else 'L2 SWITCH'

end as PRODUCT_TYPE_TXT, case

when TEMP_DEVICE.IS_FOUNDRY = 1 then 'IOS' when TEMP_DEVICE.IS_DCB_SWITCH = 1 then 'FOS' when TEMP_DEVICE.IS_VCS_CAPABLE = 1 then 'NOS' else 'UNKNOWN'

end as SWITCH_OS,

TEMP_DEVICE.IS_ROUTER, TEMP_DEVICE.IS_SLB,

TEMP_DEVICE.SERIAL_NUMBER, TEMP_DEVICE.SYS_NAME, case

when TEMP_DEVICE.SUB_CATEGORY > 0 then (select distinct VCSD.SYS_NAME 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_NAME,

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'

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