Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1365
53-1002696-01
Views
H
LUN.THIN_PROVISION_LUN
from
CRYPTO_LUN LUN,
CRYPTO_HOST
where
LUN.CRYPTO_HOST_ID = CRYPTO_HOST.ID;
CRYPTO_TARGET_ENGINE_INFO
create or replace view CRYPTO_TARGET_ENGINE_INFO as
select
CRYPTO_TARGET_CONTAINER.ID TARGET_CONTAINER_ID,
CRYPTO_TARGET_CONTAINER.NAME,
CRYPTO_TARGET_CONTAINER.VT_NODE_WWN,
CRYPTO_TARGET_CONTAINER.VT_PORT_WWN,
CRYPTO_TARGET_CONTAINER.FAILOVER_STATUS,
CRYPTO_TARGET_CONTAINER.FAILOVER_STATUS_2,
CRYPTO_TARGET_CONTAINER.DEVICE_STATUS,
CRYPTO_TARGET_CONTAINER.DEVICE_TYPE,
CRYPTO_TARGET_CONTAINER.TARGET_PORT_WWN,
CRYPTO_TARGET_CONTAINER.TARGET_NODE_WWN,
CRYPTO_TARGET_CONTAINER.CONTAINER_FIELD_DATA,
CRYPTO_TARGET_CONTAINER.CONFIGURATION_STATUS,
CRYPTO_TARGET_CONTAINER.FRONT_END_N_PORT_NUMBER,
ENCRYPTION_ENGINE.STATUS ENCRYPTION_ENGINE_STATUS,
ENCRYPTION_ENGINE.HA_CLUSTER_ID,
ENCRYPTION_ENGINE.SYSTEM_CARD_STATUS,
ENCRYPTION_ENGINE.WWN_POOLS_AVAILABLE,
ENCRYPTION_ENGINE.STATE ENCRYPTION_ENGINE_STATE,
ENCRYPTION_ENGINE.ID ENCRYPTION_ENGINE_ID,
CRYPTO_SWITCH.SWITCH_ID SWITCH_ID,
CRYPTO_SWITCH.ENCRYPTION_GROUP_ID ENCRYPTION_GROUP_ID
from
CRYPTO_TARGET_CONTAINER,
ENCRYPTION_ENGINE,
CRYPTO_SWITCH
where
CRYPTO_TARGET_CONTAINER.ENCRYPTION_ENGINE_ID = ENCRYPTION_ENGINE.ID
and CRYPTO_SWITCH.SWITCH_ID = ENCRYPTION_ENGINE.SWITCH_ID;
DEPLOYMENT_INFO
create or replace view DEPLOYMENT_INFO as
select
DEPLOYMENT_CONFIGURATION.ID as ID,
DEPLOYMENT_CONFIGURATION.NAME as NAME,
DEPLOYMENT_CONFIGURATION.DESCRIPTION as DESCRIPTION,
DEPLOYMENT_HANDLER.MODULE as MODULE,
DEPLOYMENT_HANDLER.SUB_MODULE as SUB_MODULE,
DEPLOYMENT_STATUS.DEPLOYMENT_TIME as DEPLOYMENT_TIME,
DEPLOYMENT_CONFIGURATION.DEPLOY_OPTION as DEPLOYMENT_OPTION,
DEPLOYMENT_STATUS.STATUS as STATUS,
DEPLOYMENT_STATUS.DEPLOYED_BY as DEPLOYED_BY,
DEPLOYMENT_CONFIGURATION.CREATED_BY as CREATOR,
DEPLOYMENT_CONFIGURATION.SCHEDULE_ENABLED as SCHEDULE_ENABLED,
DEPLOYMENT_CONFIGURATION.SNAPSHOT_ENABLED as SNAPSHOT_ENABLED,
SCHEDULE_ENTRY.TYPE as FREQUENCY,
DEPLOYMENT_CONFIGURATION.MANAGEMENT_FLAG,