1606 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
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;
DASHBOARD_PREFERENCES_INFO
CREATE VIEW dashboard_preferences_info AS
select
DASHBOARD.NAME as DASHBOARD_NAME,
DASHBOARD.DESCRIPTION as DASHBOARD_DESC,
DASHBOARD.CREATED_BY,
DASHBOARD_CANVAS.NAME as CANVAS_NAME,
DASHBOARD_CANVAS.DESCRIPTION as CANVAS_DESC,
DASHBOARD_CANVAS_PREFERENCE.SCOPE_ID,
DASHBOARD_CANVAS_PREFERENCE.SCOPE_TYPE,
DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_ID,
DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_CANVAS_ID,
DASHBOARD_CANVAS_PREFERENCE.VISIBLE,
DASHBOARD_CANVAS_PREFERENCE.TIME_SCOPE
from
DASHBOARD,
DASHBOARD_CANVAS,
DASHBOARD_CANVAS_PREFERENCE
where
DASHBOARD.ID = DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_ID
and DASHBOARD_CANVAS.ID = DASHBOARD_CANVAS_PREFERENCE.DASHBOARD_CANVAS_ID;