Views I

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

LUN.THIN_PROVISION_LUN from

CRYPTO_LUN LUN, CRYPTO_HOST

where

LUN.CRYPTO_HOST_ID = CRYPTO_HOST.ID;

Brocade Network Advisor IP User Manual

1605

53-1003056-01

 

Page 1657
Image 1657
Brocade Communications Systems IP250 Cryptohostluninfo, Coreswitchdetails.Description, Cryptolun LUN, Cryptohost