User's Manual

Brocade Network Advisor IP User Manual 1649
53-1003056-01
Views
I
and EG.ID = RCGM.ENCRYPTION_GROUP_ID
and SC.CARD_TYPE = 1
union
select
SC.ID SMART_CARD_ID,
SC.CARD_TYPE,
SC.CARD_INFO,
SC.CARDCN_ID,
SC.FIRST_NAME,
SC.LAST_NAME,
SC.NOTES,
SC.CREATION_TIME,
EE.ID ENGINE_ID,
-1 ENCRYPTION_GROUP_ID,
'' GROUP_NAME,
-1 CARD_POSITION,
EE.SWITCH_ID CRYPTO_SWITCH_ID,
EE.SLOT_NUMBER SLOT_NUMBER
from
SMART_CARD SC,
ENCRYPTION_ENGINE EE,
SYSTEM_CARD_ENGINE_MAPPING SCEM
where
SC.ID = SCEM.SMART_CARD_ID
and EE.ID = SCEM.ENCRYPTION_ENGINE_ID
and SC.CARD_TYPE = 2;
SWITCH_CONFIG_INFO
create or replace view SWITCH_CONFIG_INFO as
select
SWITCH_CONFIG.ID,
SWITCH_CONFIG.NAME,
SWITCH_CONFIG.SWITCH_ID,
SWITCH_CONFIG.CORE_SWITCH_ID,
SWITCH_CONFIG.BACKUP_DATE_TIME,
SWITCH_CONFIG.CONFIG_DATA,
SWITCH_CONFIG.CEE_CONFIG_DATA,
SWITCH_CONFIG.KEEP_COPY,
SWITCH_CONFIG.CREATED_BY,
SWITCH_CONFIG.COMMENTS,
SWITCH_CONFIG.CONFIG_TYPE,
SWITCH_CONFIG_DETAIL.IP_ADDRESS,
SWITCH_CONFIG_DETAIL.WWN,
SWITCH_CONFIG_DETAIL.PHYSICAL_SWITCH_WWN,
SWITCH_CONFIG_DETAIL.MODEL_NUMBER as SWITCH_MODEL_NUMBER
from
SWITCH_CONFIG,
SWITCH_CONFIG_DETAIL
where
SWITCH_CONFIG.ID= SWITCH_CONFIG_DETAIL.SWITCH_CONFIG_ID;
SWITCH_DETAILS_INFO
CREATE VIEW switch_details_info AS
select
CORE_SWITCH.ID as PHYSICAL_SWITCH_ID,
CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME,