Brocade Network Advisor IP User Manual 1687
53-1003056-01
Views I
VIRTUAL_SWITCH.MANAGED_ELEMENT_ID,
VIRTUAL_SWITCH.MONITORED,
SWITCH_PORT.USER_PORT_NUMBER,
SWITCH_PORT.STATE,
SWITCH_PORT.STATUS,
SWITCH_PORT.NAME,
SWITCH_PORT.LICENSED,
SWITCH_PORT.TRUNKED,
SWITCH_PORT.TRUNK_MASTER,
SWITCH_PORT.SPEED_TYPE
from
CEE_PORT, GIGE_PORT, SWITCH_PORT, VIRTUAL_SWITCH, CORE_SWITCH
where
CEE_PORT.GIGE_PORT_ID = GIGE_PORT.ID
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID
and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID;