Crypto_host_lun_info – Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual
Page 2284
Brocade Network Advisor SAN + IP User Manual
2247
53-1002949-01
Views
I
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,
LUN.TIME_LEFT_FOR_AUTO_REKEY,
CRYPTO_HOST.HOST_PORT_WWN,
CRYPTO_HOST.HOST_NODE_WWN