HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 208
Switch_port_info, And Core_switch_details.core_switch_id = Core_switch.id
![]() |
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 208 highlights
E Views CORE_SWITCH_DETAILS.TAG, CORE_SWITCH_DETAILS.ACT_CP_PRI_FW_VERSION, CORE_SWITCH_DETAILS.ACT_CP_SEC_FW_VERSION, CORE_SWITCH_DETAILS.STBY_CP_PRI_FW_VERSION, CORE_SWITCH_DETAILS.STBY_CP_SEC_FW_VERSION, CORE_SWITCH_DETAILS.TYPE as DETAILS_TYPE, CORE_SWITCH_DETAILS.EGM_CAPABLE, CORE_SWITCH_DETAILS.SUB_TYPE, CORE_SWITCH_DETAILS.PARTITION, CORE_SWITCH_DETAILS.MAX_NUM_OF_BLADES, CORE_SWITCH_DETAILS.SNMP_INFORMS_ENABLED, CORE_SWITCH_DETAILS.VENDOR_VERSION, CORE_SWITCH_DETAILS.VENDOR_PART_NUMBER, CORE_SWITCH_DETAILS.CONTACT, CORE_SWITCH_DETAILS.LOCATION, CORE_SWITCH_DETAILS.DESCRIPTION, CORE_SWITCH_DETAILS.RNID_SEQUENCE_NUMBER, CORE_SWITCH_DETAILS.FIRMWARE_VERSION as CSD_FIRMWARE_VERSION from CORE_SWITCH, VIRTUAL_SWITCH, FABRIC_MEMBER, CORE_SWITCH_DETAILS where VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and FABRIC_MEMBER.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID; SWITCH_PORT_INFO create or replace view SWITCH_PORT_INFO as select SWITCH_PORT.ID, SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.WWN, SWITCH_PORT.NAME, SWITCH_PORT.SLOT_NUMBER, SWITCH_PORT.PORT_NUMBER, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.PORT_ID, SWITCH_PORT.PORT_INDEX, SWITCH_PORT.AREA_ID, SWITCH_PORT.MAC_ADDRESS, SWITCH_PORT.PORT_MOD, SWITCH_PORT.TYPE, SWITCH_PORT.FULL_TYPE, SWITCH_PORT.STATUS, SWITCH_PORT.HEALTH, SWITCH_PORT.STATUS_MESSAGE, SWITCH_PORT.PHYSICAL_PORT, SWITCH_PORT.LOCKED_PORT_TYPE, SWITCH_PORT.CATEGORY, SWITCH_PORT.PROTOCOL, SWITCH_PORT.SPEED, SWITCH_PORT.SPEEDS_SUPPORTED, SWITCH_PORT.MAX_PORT_SPEED, SWITCH_PORT.DESIRED_CREDITS, SWITCH_PORT.BUFFER_ALLOCATED, SWITCH_PORT.ESTIMATED_DISTANCE, 200 Brocade Network Advisor Documentation Updates 53-1002363-02
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/208.png)