I Views

FRU.TAG,

FRU.PART_NUMBER, FRU.SERIAL_NUMBER, FRU.VENDOR_PART_NUMBER, FRU.VENDOR_SERIAL_NUMBER, FRU.CAN_BE_FRUED, FRU.SLOT_NUMBER, FRU.MANUFACTURER_DATE, FRU.UPDATE_DATE, FRU.VERSION, FRU.MANUFACTURER, FRU.VENDOR_EQUIPMENT_TYPE, FRU.OPERATIONAL_STATUS, FRU.TOTAL_OUTPUT_POWER, FRU.SPEED,

FRU.CREATION_TIME, FRU.LAST_UPDATE_TIME,

FRU.PREVIOUS_OP_STATUS, FRU.VENDOR,

CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,

VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE,

VIRTUAL_SWITCH.MANAGEMENT_STATE, VIRTUAL_SWITCH.MONITORED

from

FRU,

CORE_SWITCH, VIRTUAL_SWITCH

where

FRU.CORE_SWITCH_ID = CORE_SWITCH.ID and

FRU.CORE_SWITCH_ID = VIRTUAL_SWITCH.CORE_SWITCH_ID;

GIGE_PORT_ECLOUD_LINK_INFO

create or replace view GIGE_PORT_ECLOUD_LINK_INFO as select

GIGE_PORT_ETHERNET_CLOUD_LINK.ID,

GIGE_PORT_ETHERNET_CLOUD_LINK.SWITCH_PORT_ID as GIGE_PORT_ID,

GIGE_PORT_ETHERNET_CLOUD_LINK.CLOUD_ID,

GIGE_PORT_ETHERNET_CLOUD_LINK.TRUSTED,

GIGE_PORT_ETHERNET_CLOUD_LINK.CREATION_TIME, GIGE_PORT_ETHERNET_CLOUD_LINK.MISSING, GIGE_PORT_ETHERNET_CLOUD_LINK.MISSING_TIME, GIGE_PORT.SWITCH_PORT_ID, GIGE_PORT.PORT_TYPE,

SWITCH_PORT.VIRTUAL_SWITCH_ID,

SWITCH_PORT.USER_PORT_NUMBER, VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID

from

GIGE_PORT_ETHERNET_CLOUD_LINK, GIGE_PORT,

SWITCH_PORT, VIRTUAL_SWITCH

where

GIGE_PORT_ETHERNET_CLOUD_LINK.SWITCH_PORT_ID = GIGE_PORT.ID and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID and

SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID;

1626

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1678
Image 1678
Brocade Communications Systems IP250 user manual Gigeportecloudlinkinfo