HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 194
Fru_info, Gige_port_ecloud_link_info, Gige_port_ethernet_cloud_link.switch_port_id As Gige_port_id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 194 highlights
E Views 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 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 186 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/194.png)