Brocade Communications Systems IP250 Moduleinfo, Tempmodule.Moduleid Tempmodule.Numports

Views I

INTERFACE.NAME AS INTERFACE_NAME,

SWITCH_PORT.WWN AS SWITCH_PORT_WWN,

SWITCH_PORT.SLOT_NUMBER AS SWITCH_PORT_SLOT,

SWITCH_PORT.PORT_NUMBER AS SWITCH_PORT_NUMBER,

SWITCH_PORT.PORT_ID AS SWITCH_PORT_PORT_ID,

FCIP_TUNNEL_CIRCUIT.CIRCUIT_NUMBER,

FCIP_TUNNEL_CIRCUIT.SLOT_NUMBER AS FCIP_SLOT_NUMBER,

FCIP_TUNNEL_CIRCUIT.VE_PORT_NUMBER AS FCIP_PORT_NUMBER,

NP_FLOW_DEFINITION.NAME AS FLOW_NAME,

MAPS_EVENT_CAUSE_ACTION.ACTION

FROM MAPS_EVENT_DETAILS

JOIN MAPS_EVENT ON MAPS_EVENT.ID = MAPS_EVENT_DETAILS.MAPS_EVENT_ID LEFT JOIN MAPS_EVENT_CAUSE_ACTION ON MAPS_EVENT.VIOLATION_TYPE =

MAPS_EVENT_CAUSE_ACTION.VIOLATION_TYPE

LEFT JOIN VIRTUAL_SWITCH ON MAPS_EVENT.MANAGED_ELEMENT_ID = VIRTUAL_SWITCH.MANAGED_ELEMENT_ID

LEFT JOIN SWITCH_PORT ON MAPS_EVENT.SWITCH_PORT_ID = SWITCH_PORT.ID LEFT JOIN INTERFACE ON MAPS_EVENT.INTERFACE_ID = INTERFACE.INTERFACE_ID LEFT JOIN FCIP_TUNNEL_CIRCUIT ON MAPS_EVENT.FCIP_CIRCUIT_ID =

FCIP_TUNNEL_CIRCUIT.ID

LEFT JOIN NP_FLOW_DEFINITION ON MAPS_EVENT.FLOW_DEFINITION_ID = NP_FLOW_DEFINITION.ID;

MODULE_INFO

CREATE VIEW module_info AS select distinct

TEMP_MODULE.MODULE_ID,

TEMP_MODULE.NUM_PORTS,

TEMP_MODULE.IS_PRESENT, case

when TEMP_MODULE.IS_PRESENT = 1 then 'YES' else 'NO'

end as IS_PRESENT_TXT,

TEMP_MODULE.IS_MANAGEMENT_MODULE, case

when TEMP_MODULE.IS_MANAGEMENT_MODULE = 1 then 'YES' else 'NO'

end as IS_MANAGEMENT_MODULE_TXT, TEMP_MODULE.NUM_CPUS,

TEMP_MODULE.HW_REVISION,

TEMP_MODULE.SW_REVISION, TEMP_MODULE.SLOT_NUM,

TEMP_MODULE.DEVICE_ID,

TEMP_MODULE.PHYSICAL_DEVICE_ID, TEMP_MODULE.UNIT_NUMBER, TEMP_MODULE.UNIT_PRESENT, case

when TEMP_MODULE.UNIT_PRESENT = 1 then 'YES' else 'NO'

end as UNIT_PRESENT_TXT,

TEMP_MODULE.MANAGED_ELEMENT_ID, TEMP_MODULE.IP_ADDRESS, TEMP_FOUNDRY_MODULE.SERIAL_NUM, TEMP_FOUNDRY_MODULE.DRAM_SIZE, TEMP_FOUNDRY_MODULE.BOOT_FLASH_SIZE,

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