HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 206
Switch_details_info, Core_switch.last_update_time As Cs_last_update_time
View all HP Brocade 8/12c manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 206 highlights
E Views SMART_CARD SC, ENCRYPTION_GROUP EG, RECOVERY_CARD_GROUP_MAPPING RCGM where SC.ID = RCGM.SMART_CARD_ID and EG.ID = RCGM.ENCRYPTION_GROUP_ID and SC.CARD_TYPE = 1 union select SC.ID SMART_CARD_ID, SC.CARD_TYPE, SC.CARD_INFO, SC.CARDCN_ID, SC.FIRST_NAME, SC.LAST_NAME, SC.NOTES, SC.CREATION_TIME, EE.ID ENGINE_ID, -1 ENCRYPTION_GROUP_ID, '' GROUP_NAME, -1 CARD_POSITION, EE.SWITCH_ID CRYPTO_SWITCH_ID, EE.SLOT_NUMBER SLOT_NUMBER from SMART_CARD SC, ENCRYPTION_ENGINE EE, SYSTEM_CARD_ENGINE_MAPPING SCEM where SC.ID = SCEM.SMART_CARD_ID and EE.ID = SCEM.ENCRYPTION_ENGINE_ID and SC.CARD_TYPE = 2; SWITCH_DETAILS_INFO create or replace view SWITCH_DETAILS_INFO as select CORE_SWITCH.ID as PHYSICAL_SWITCH_ID, CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME, CORE_SWITCH.IP_ADDRESS, CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN, CORE_SWITCH.OPERATIONAL_STATUS as PHYSICAL_OPERATIONAL_STATUS, CORE_SWITCH.TYPE, CORE_SWITCH.MAX_VIRTUAL_SWITCHES, CORE_SWITCH.FIRMWARE_VERSION, CORE_SWITCH.VENDOR, CORE_SWITCH.REACHABLE, CORE_SWITCH.UNREACHABLE_TIME, CORE_SWITCH.MODEL, CORE_SWITCH.SYSLOG_REGISTERED, CORE_SWITCH.SNMP_REGISTERED, CORE_SWITCH.USER_IP_ADDRESS, CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS, CORE_SWITCH.CREATION_TIME as CS_CREATION_TIME, CORE_SWITCH.LAST_UPDATE_TIME as CS_LAST_UPDATE_TIME, CORE_SWITCH.NUM_VIRTUAL_SWITCHES, CORE_SWITCH.VF_ENABLED, CORE_SWITCH.VF_SUPPORTED, CORE_SWITCH.CALL_HOME_ENABLED, CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID, 198 Brocade Network Advisor Documentation Updates 53-1002363-02