Devportgigeportlinkinfo | Brocade Communications Systems IP250

Views I

FICON_DEVICE_PORT.FLAG, FICON_DEVICE_PORT.PARAMS, USER_DEFINED_DEVICE_DETAIL.NAME,

USER_DEFINED_DEVICE_DETAIL.TYPE as USER_DEFINED_TYPE,

USER_DEFINED_DEVICE_DETAIL.IP_ADDRESS, USER_DEFINED_DEVICE_DETAIL.CONTACT, USER_DEFINED_DEVICE_DETAIL.LOCATION, USER_DEFINED_DEVICE_DETAIL.DESCRIPTION, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE1, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE2, USER_DEFINED_DEVICE_DETAIL.USER_DEFINED_VALUE3, DEVICE_NODE.WWN as DEVICE_NODE_WWN,

DEVICE_NODE.FDMI_HOST_NAME,

DEVICE_NODE.SYMBOLIC_NAME as DEVICE_SYMBOLIC_NAME, DEVICE_NODE.AG as AG_PORT,

coalesce(SWITCH_PORT.NAME, VIRTUAL_FCOE_PORT.NAME) as SWITCH_PORT_NAME, coalesce (SWITCH_PORT.TYPE, VIRTUAL_FCOE_PORT.PORT_TYPE) as SWITCH_PORT_TYPE,

SWITCH_PORT.LOGICAL_PORT_WWN, coalesce(VS1.WWN, VS2.WWN) as SWITCH_WWN,

coalesce(VS1.MANAGEMENT_STATE, VS2.MANAGEMENT_STATE) as MANAGEMENT_STATE, coalesce(VS1.MONITORED, VS2.MONITORED) as MONITORED, FABRIC.PRINCIPAL_SWITCH_WWN as PRINCIPAL_WWN,

FABRIC.ID as FABRIC_ID

from

DEVICE_PORT

left outer join USER_DEFINED_DEVICE_DETAIL

on DEVICE_PORT.WWN = USER_DEFINED_DEVICE_DETAIL.WWN left outer join FICON_DEVICE_PORT

on DEVICE_PORT.ID = FICON_DEVICE_PORT.DEVICE_PORT_ID left outer join DEVICE_NODE

on DEVICE_PORT.NODE_ID = DEVICE_NODE.ID left outer join SWITCH_PORT

on DEVICE_PORT.SWITCH_PORT_WWN = SWITCH_PORT.WWN left outer join VIRTUAL_FCOE_PORT

on DEVICE_PORT.SWITCH_PORT_WWN = VIRTUAL_FCOE_PORT.PORT_WWN left outer join VIRTUAL_SWITCH VS1

on SWITCH_PORT.VIRTUAL_SWITCH_ID = VS1.ID left outer join VIRTUAL_SWITCH VS2

on VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VS2.ID left outer join FABRIC

on DEVICE_NODE.FABRIC_ID = FABRIC.ID;