Brocade Communications Systems IP250 user manual Switchconfiginfo, Switchdetailsinfo

Views I

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, SWITCH_CONFIG_DETAIL.IP_ADDRESS, SWITCH_CONFIG_DETAIL.WWN, SWITCH_CONFIG_DETAIL.PHYSICAL_SWITCH_WWN,

SWITCH_CONFIG_DETAIL.MODEL_NUMBER as SWITCH_MODEL_NUMBER

from

SWITCH_CONFIG, SWITCH_CONFIG_DETAIL

where

SWITCH_CONFIG.ID= SWITCH_CONFIG_DETAIL.SWITCH_CONFIG_ID;

SWITCH_DETAILS_INFO

CREATE VIEW switch_details_info AS select

CORE_SWITCH.ID as PHYSICAL_SWITCH_ID, CORE_SWITCH.NAME as PHYSICAL_SWITCH_NAME,

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