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

1554 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
SENSOR_INFO
create or replace view SENSOR_INFO as
select
SENSOR.ID,
SENSOR.CORE_SWITCH_ID,
SENSOR.SENSOR_ID,
SENSOR.CURRENT_READING,
SENSOR.TYPE,
SENSOR.SUB_TYPE,
SENSOR.DESCRIPTION,
SENSOR.STATUS,
SENSOR.OPERATIONAL_STATUS,
SENSOR.PART_NUMBER,
SENSOR.SERIAL_NUMBER,
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,
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