Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1171
53-1002167-01
Views
E
SENSOR.VERSION,
SENSOR.CREATION_TIME,
SENSOR.LAST_UPDATE_TIME,
SENSOR.FRU_TYPE,
SENSOR.UNIT_NUMBER,
SENSOR.STATE,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,
VIRTUAL_SWITCH.SWITCH_MODE as VIRTUAL_SWITCH_MODE
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