1604 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
CORE_SWITCH_DETAILS_INFO
create or replace view CORE_SWITCH_DETAILS_INFO as
select
CORE_SWITCH.ID,
CORE_SWITCH.IP_ADDRESS,
CORE_SWITCH.WWN,
CORE_SWITCH.NAME,
CORE_SWITCH.TYPE,
CORE_SWITCH.MODEL,
CORE_SWITCH.FIRMWARE_VERSION,
CORE_SWITCH.VENDOR,
CORE_SWITCH.MAX_VIRTUAL_SWITCHES,
CORE_SWITCH.NUM_VIRTUAL_SWITCHES,
CORE_SWITCH.REACHABLE,
CORE_SWITCH.UNREACHABLE_TIME,
CORE_SWITCH.OPERATIONAL_STATUS,
CORE_SWITCH.CREATION_TIME,
CORE_SWITCH.LAST_SCAN_TIME,
CORE_SWITCH.LAST_UPDATE_TIME,
CORE_SWITCH.SYSLOG_REGISTERED,
CORE_SWITCH.CALL_HOME_ENABLED,
CORE_SWITCH.SNMP_REGISTERED,
CORE_SWITCH.USER_IP_ADDRESS,
CORE_SWITCH.NIC_PROFILE_ID,
CORE_SWITCH.MANAGING_SERVER_IP_ADDRESS,
CORE_SWITCH.VF_ENABLED,
CORE_SWITCH.VF_SUPPORTED,
CORE_SWITCH.MANAGED_ELEMENT_ID as CORE_MANAGED_ELEMENT_ID,
CORE_SWITCH_DETAILS.ETHERNET_MASK,
CORE_SWITCH_DETAILS.FC_MASK,
CORE_SWITCH_DETAILS.FC_IP,
CORE_SWITCH_DETAILS.FC_CERTIFICATE,
CORE_SWITCH_DETAILS.SW_LICENSE_ID,
CORE_SWITCH_DETAILS.SUPPLIER_SERIAL_NUMBER,
CORE_SWITCH_DETAILS.PART_NUMBER,
CORE_SWITCH_DETAILS.CHECK_BEACON,
CORE_SWITCH_DETAILS.TIMEZONE,
CORE_SWITCH_DETAILS.MAX_PORT,
CORE_SWITCH_DETAILS.CHASSIS_SERVICE_TAG,
CORE_SWITCH_DETAILS.BAY_ID,
CORE_SWITCH_DETAILS.TYPE_NUMBER,
CORE_SWITCH_DETAILS.MODEL_NUMBER,
CORE_SWITCH_DETAILS.MANUFACTURER,
CORE_SWITCH_DETAILS.PLANT_OF_MANUFACTURER,
CORE_SWITCH_DETAILS.SWITCH_SERIAL_NUMBER,
CORE_SWITCH_DETAILS.ACT_CP_PRI_FW_VERSION,
CORE_SWITCH_DETAILS.ACT_CP_SEC_FW_VERSION,
CORE_SWITCH_DETAILS.STBY_CP_PRI_FW_VERSION,
CORE_SWITCH_DETAILS.STBY_CP_SEC_FW_VERSION,
CORE_SWITCH_DETAILS.EGM_CAPABLE,
CORE_SWITCH_DETAILS.SUB_TYPE,
CORE_SWITCH_DETAILS.PARTITION,
CORE_SWITCH_DETAILS.MAX_NUM_OF_BLADES,
CORE_SWITCH_DETAILS.VENDOR_VERSION,
CORE_SWITCH_DETAILS.VENDOR_PART_NUMBER,
CORE_SWITCH_DETAILS.RNID_SEQUENCE_NUMBER,
CORE_SWITCH_DETAILS.CONTACT,
CORE_SWITCH_DETAILS.LOCATION,