Crypto_host_lun_info – Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1814

Advertising
background image

1762

Brocade Network Advisor SAN User Manual

53-1003154-01

Views

H

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,

CORE_SWITCH_DETAILS.IP_ADDRESS_PREFIX,

CORE_SWITCH_DETAILS.DOMAIN_NAME,

CORE_SWITCH_DETAILS.FRAME_LOG_SIZE,

CORE_SWITCH_DETAILS.FRAME_LOG_ENABLED,

CORE_SWITCH_DETAILS.MAPS_ENABLED

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,

LUN.ENCRYPTION_ALGORITHM,

LUN.KEY_ID_STATE,

LUN.REKEY_SESSION_NUMBER,

LUN.PERCENTAGE_COMPLETE,

LUN.REKEY_ROLE,

LUN.CURRENT_LBA,

LUN.LUN_STATE_STRING,

LUN.NEW_LUN,

LUN.NEW_LUN_TYPE,

LUN.DISABLE_WRITE_EARLY_ACK,

LUN.DISABLE_READ_AHEAD,

Advertising