1648 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MONITORED
from
SENSOR,
CORE_SWITCH,
VIRTUAL_SWITCH
where
SENSOR.CORE_SWITCH_ID = CORE_SWITCH.ID and
SENSOR.CORE_SWITCH_ID = VIRTUAL_SWITCH.CORE_SWITCH_ID;
SMART_CARD_USAGE_INFO
create or replace view SMART_CARD_USAGE_INFO as
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,
-1 ENGINE_ID,
EG.ID ENCRYPTION_GROUP_ID,
EG.NAME GROUP_NAME,
-1 CARD_POSITION,
-1 CRYPTO_SWITCH_ID,
-1 SLOT_NUMBER
from
SMART_CARD SC,
ENCRYPTION_GROUP EG,
QUORUM_CARD_GROUP_MAPPING QCGM
where
QCGM.SMART_CARD_ID = SC.ID
and EG.ID = QCGM.ENCRYPTION_GROUP_ID
and SC.CARD_TYPE = 0
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,
-1 ENGINE_ID,
EG.ID ENCRYPTION_GROUP_ID,
EG.NAME GROUP_NAME,
RCGM.POSITION_ CARD_POSITION,
-1 CRYPTO_SWITCH_ID,
-1 SLOT_NUMBER
from
SMART_CARD SC,
ENCRYPTION_GROUP EG,
RECOVERY_CARD_GROUP_MAPPING RCGM
where
SC.ID = RCGM.SMART_CARD_ID