Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1516 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
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;
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,