Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1694)

1640 Brocade Network Advisor IP User Manual
53-1002947-01
Views
I
FRU_INFO
create or replace view FRU_INFO as
select
FRU.ID,
FRU.CORE_SWITCH_ID,
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