I Views

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;

1606

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1658
Image 1658
Brocade Communications Systems IP250 user manual Cryptotargetengineinfo, Dashboardpreferencesinfo, Dashboard.Createdby