Filter
Top Products
Brocade Network Advisor IP User Manual 1637
53-1003056-01
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,