HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 181
Crypto_host_lun_info, On 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 181 highlights
CORE_SWITCH_DETAILS.FC_CERTIFICATE, CORE_SWITCH_DETAILS.SW_LICENSE_ID, CORE_SWITCH_DETAILS.SUPPLIER_SERIAL_NUMBER, CORE_SWITCH_DETAILS.PART_NUMBER, CORE_SWITCH_DETAILS.CHECK_BEACON, CORE_SWITCH_DETAILS.TIMEZONE, CORE_SWITCH_DETAILS.MAX_PORT, CORE_SWITCH_DETAILS.CHASSIS_SERVICE_TAG, CORE_SWITCH_DETAILS.BAY_ID, CORE_SWITCH_DETAILS.TYPE_NUMBER, CORE_SWITCH_DETAILS.MODEL_NUMBER, CORE_SWITCH_DETAILS.MANUFACTURER, CORE_SWITCH_DETAILS.PLANT_OF_MANUFACTURER, CORE_SWITCH_DETAILS.SEQUENCE_NUMBER, 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.EGM_CAPABLE, CORE_SWITCH_DETAILS.SUB_TYPE, CORE_SWITCH_DETAILS.PARTITION, CORE_SWITCH_DETAILS.MAX_NUM_OF_BLADES, CORE_SWITCH_DETAILS.VENDOR_VERSION, CORE_SWITCH_DETAILS.VENDOR_PART_NUMBER, CORE_SWITCH_DETAILS.RNID_SEQUENCE_NUMBER, CORE_SWITCH_DETAILS.CONTACT, CORE_SWITCH_DETAILS.LOCATION, CORE_SWITCH_DETAILS.DESCRIPTION from CORE_SWITCH LEFT OUTER JOIN CORE_SWITCH_DETAILS on CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID; CRYPTO_HOST_LUN_INFO create or replace view CRYPTO_HOST_LUN_INFO as select LUN.CRYPTO_HOST_ID, LUN.ID CRYPTO_LUN_ID, LUN.LUN_NUMBER, LUN.CRYPTO_TARGET_CONTAINER_ID, LUN.SERIAL_NUMBER, LUN.ENCRYPTION_STATE, LUN.STATUS, LUN.REKEY_INTERVAL, LUN.VOLUME_LABEL_PREFIX, LUN.LAST_REKEY_DATE, LUN.LAST_REKEY_STATUS, LUN.LAST_REKEY_PROGRESS, LUN.CURRENT_VOLUME_LABEL, LUN.PRIOR_ENCRYPTION_STATE, LUN.ENCRYPTION_FORMAT, LUN.ENCRYPT_EXISTING_DATA, LUN.DECRYPT_EXISTING_DATA, LUN.KEY_ID, LUN.BLOCK_SIZE, LUN.TOTAL_BLOCKS, LUN.LUN_STATE, LUN.LUN_FLAGS, Brocade Network Advisor Documentation Updates 53-1002363-02 Views E 173
![](/manual_guide/products/hewlettpackard-brocade-812c-brocade-network-advisor-documentation-updates-v111x-53100236303-2011-4c13200/181.png)