Brocade Communications Systems IP250 user manual Smartcardusageinfo

I Views

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

1648	Brocade Network Advisor IP User Manual
	53-1003056-01