Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2595)

Brocade Network Advisor SAN + IP User Manual 2523
53-1003155-01
Views
I
EVENT_DETAILS.RAS_LOG_ID as RAS_LOG_ID,
EVENT_DETAILS.PRODUCT_ADDRESS as PRODUCT_ADDRESS,
EVENT_DETAILS.CONTRIBUTORS as CONTRIBUTORS,
EVENT_DETAILS.NODE_WWN as NODE_WWN,
EVENT_DETAILS.OPERATIONAL_STATUS as OPERATIONAL_STATUS,
EVENT_DETAILS.FIRST_OCCURRENCE_SWITCH_TIME as FIRST_OCCURRENCE_SWITCH_TIME,
EVENT_DETAILS.LAST_OCCURRENCE_SWITCH_TIME as LAST_OCCURRENCE_SWITCH_TIME,
EVENT_DETAILS.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID,
EVENT_DETAILS.USER_NAME as USER_NAME,
EVENT_DETAILS.PORT_NAME as PORT_NAME,
EVENT_DETAILS.MAC_ADDRESS
from
EVENT
left join EVENT_DETAILS on EVENT.ID = EVENT_DETAILS.EVENT_ID,
EVENT_ORIGIN, EVENT_CATEGORY, EVENT_MODULE, EVENT_DESCRIPTION
where EVENT.EVENT_ORIGIN_ID = EVENT_ORIGIN.ID and EVENT.EVENT_CATEGORY_ID
= EVENT_CATEGORY.ID and EVENT.EVENT_MODULE_ID = EVENT_MODULE.ID
and EVENT.EVENT_DESCRIPTION_ID = EVENT_DESCRIPTION.ID;
FABRIC_INFO
create or replace view FABRIC_INFO as
select
FABRIC.ID,
FABRIC.SAN_ID,
FABRIC.SEED_SWITCH_WWN,
FABRIC.NAME,
FABRIC.ACTIVE_ZONESET_NAME,
FABRIC.MANAGEMENT_STATE,
FABRIC.LAST_FABRIC_CHANGED,
FABRIC.SECURE,
FABRIC.AD_ENVIRONMENT,
FABRIC.MANAGED,
FABRIC.CONTACT,
FABRIC.LOCATION,
FABRIC.DESCRIPTION,
FABRIC.CREATION_TIME,
FABRIC.LAST_SCAN_TIME,
FABRIC.LAST_UPDATE_TIME,
FABRIC.TRACK_CHANGES,
FABRIC.TYPE,
FABRIC.HAS_NOS_AG,
FABRIC.USER_DEFINED_VALUE_1,
FABRIC.USER_DEFINED_VALUE_2,
FABRIC.USER_DEFINED_VALUE_3,
FABRIC.PRINCIPAL_SWITCH_WWN,
FABRIC.ZONE_TRANSACTION_TIMEOUT,
FABRIC.FABRIC_MODEL,
FABRIC.ENHANCED_TI_ZONE_SUPPORT,
FABRIC.FABRIC_NAME,
VIRTUAL_SWITCH.ID as SEED_SWITCH_ID,
VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID,
VIRTUAL_SWITCH.INTEROP_MODE,
CORE_SWITCH.IP_ADDRESS as SEED_SWITCH_IP_ADDRESS,
(select count(*) from FABRIC_MEMBER
where FABRIC_MEMBER.FABRIC_ID = FABRIC.ID) as SWITCH_COUNT
from
FABRIC, CORE_SWITCH, VIRTUAL_SWITCH
where