
1824
Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
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
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,
Summary of Contents for Network Advisor 12.3.0
Page 4: ...iv Brocade Network Advisor SAN User Manual 53 1003154 01...
Page 86: ...34 Brocade Network Advisor SAN User Manual 53 1003154 01 Uninstalling a patch 2...
Page 190: ...138 Brocade Network Advisor SAN User Manual 53 1003154 01 Fabric tracking 4...
Page 216: ...164 Brocade Network Advisor SAN User Manual 53 1003154 01 User profiles 5...
Page 612: ...560 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting Host port mapping 13...
Page 620: ...568 Brocade Network Advisor SAN User Manual 53 1003154 01 Exporting storage port mapping 14...
Page 720: ...668 Brocade Network Advisor SAN User Manual 53 1003154 01 Security configuration deployment 17...
Page 744: ...692 Brocade Network Advisor SAN User Manual 53 1003154 01 Configuring Virtual Fabrics 19...
Page 1068: ...1016 Brocade Network Advisor SAN User Manual 53 1003154 01 Removing thresholds 24...
Page 1098: ...1046 Brocade Network Advisor SAN User Manual 53 1003154 01 Swapping blades 25...
Page 1176: ...1124 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN connection utilization 28...
Page 1378: ...1326 Brocade Network Advisor SAN User Manual 53 1003154 01 Event logs 32...
Page 1448: ...1396 Brocade Network Advisor SAN User Manual 53 1003154 01 Upload failure data capture 34...
Page 1490: ...1438 Brocade Network Advisor SAN User Manual 53 1003154 01 SAN shortcut menus A...
Page 1494: ...1442 Brocade Network Advisor SAN User Manual 53 1003154 01 Call Home Event Tables B...
Page 1524: ...1472 Brocade Network Advisor SAN User Manual 53 1003154 01 About Roles and Access Levels D...
Page 1552: ...1500 Brocade Network Advisor SAN User Manual 53 1003154 01 Regular Expressions F...
Page 1920: ...1868 Brocade Network Advisor SAN User Manual 53 1003154 01 Views H...