Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1839)

Brocade Network Advisor SAN User Manual 1787
53-1003154-01
Views
H
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;
GIGE_PORT_INFO
create or replace view GIGE_PORT_INFO as
select
GIGE_PORT.ID,
GIGE_PORT.SWITCH_PORT_ID,
GIGE_PORT.PORT_NUMBER,
GIGE_PORT.SLOT_NUMBER,
GIGE_PORT.ENABLED,
GIGE_PORT.SPEED,
GIGE_PORT.MAX_SPEED,
GIGE_PORT.MAC_ADDRESS,