Brocade Communications Systems Network Advisor 12.0.0, Руководство пользователя

Страница: 1428 / 1505

1380 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
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,
GIGE_PORT.PORT_NAME,
GIGE_PORT.OPERATIONAL_STATUS,
GIGE_PORT.LED_STATE,
GIGE_PORT.SPEED_LED_STATE,
GIGE_PORT.PORT_TYPE,
GIGE_PORT.PERSISTENTLY_DISABLED,
GIGE_PORT.INTERFACE_TYPE,
GIGE_PORT.CHECKSUM,
GIGE_PORT.FCIP_CAPABLE,