SELECT CASE WHEN COUNT(tlast._ident) = 0 THEN '+'||0||' x '||text ELSE COUNT(tlast._ident)||' x '||text END AS "N x (Tipo de mensaje)" ,
severity AS "Gravedad" , CASE WHEN (completion = 'succeeded' OR completion IS NULL) THEN TRUE ELSE FALSE END AS "Completado" ,
CASE WHEN (t2.address) IS NULL OR t2.address = ' ' THEN '127.0.0.1' ELSE t2.address END AS "IP Origen" ,
CASE WHEN (t_addr) IS NULL THEN '127.0.0.1' ELSE t_addr END AS "IP Destino" ,
CASE WHEN iana_protocol_number IS NULL THEN '0' ELSE iana_protocol_number END AS "Protocolo" ,
CASE WHEN MIN(s_port) IS NULL THEN '0' ELSE MIN(s_port) END AS "Puerto Origen" ,
CASE WHEN port IS NULL THEN '0' ELSE port END AS "Puerto Destino" , name AS "Nombre" ,
CASE WHEN a_addr IS NULL THEN '127.0.0.1' ELSE a_addr END AS "Sonda" , MIN(t0.time) AS "Desde" , MAX(t0.time) AS "Hasta"
FROM
(
SELECT t0._message_ident,t0.time AT TIME ZONE 'GMT' AS time, t3.address AS t_addr, t1.text, t7.severity, t7.completion , t6.name, t12.address AS a_addr
FROM Prelude_CreateTime AS t0, Prelude_Address AS t3 , Prelude_Classification AS t1 , Prelude_Impact AS t7 , Prelude_Analyzer AS t6 ,
Prelude_Address AS t12
WHERE t0._parent_type = 'A' AND (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52')
AND ((t3.address = '127.0.0.1')) AND t3._index = 0 AND t3._parent_type = 'T' AND t3._message_ident =t0._message_ident
AND t1._message_ident =t0._message_ident AND t7._message_ident =t0._message_ident
AND t6._parent_type = 'A' AND t6._index = -1 AND t6.model IS NULL AND t6._message_ident=t0._message_ident
AND t12._index = -1 AND t12._parent_type = 'A' AND t12._message_ident =t0._message_ident
GROUP BY 1,2, 3, 4, 5, 6, 7, 8
) AS t0
LEFT JOIN
(SELECT t2._message_ident ,t2.address FROM
(SELECT t2._message_ident ,t2.address, t0.time FROM Prelude_CreateTime AS t0, Prelude_Address AS t2
WHERE ((t2.address = '192.168.100.60')) AND (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52') AND t0._parent_type = 'A' AND t2._index = 0
AND t2._parent_type = 'S' AND t2._message_ident = t0._message_ident GROUP BY 1,2,3 ) AS t2) AS t2
ON (((t2.address = '192.168.100.60')) AND t0._message_ident =t2._message_ident )
LEFT JOIN
(SELECT t11._message_ident ,t11.port AS s_port FROM
(SELECT t11._message_ident ,t11.port, t0.time FROM Prelude_CreateTime AS t0, Prelude_Service AS t11
WHERE (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52') AND t0._parent_type = 'A' AND t11._parent_type='S'
AND t11._message_ident = t0._message_ident GROUP BY 1,2,3 ) AS t11) AS t11
ON (t0._message_ident =t11._message_ident )
LEFT JOIN
(SELECT t5._message_ident ,t5.port AS port, t5.iana_protocol_number FROM
(SELECT t5._message_ident ,t5.port, t5.iana_protocol_number, t0.time FROM Prelude_CreateTime AS t0, Prelude_Service AS t5
WHERE (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52') AND t0._parent_type = 'A' AND t5._parent_type='T'
AND t5._message_ident = t0._message_ident GROUP BY 1,2,3,4 ) AS t5) AS t5
ON (t0._message_ident =t5._message_ident )
LEFT JOIN
(SELECT _message_ident AS _ident,time FROM
(SELECT t0._message_ident,t0.time FROM Prelude_CreateTime AS t0
WHERE t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52' AND _parent_type = 'A' GROUP BY 1,2) AS t0) AS tlast
ON (((t2.address = '192.168.100.60')) AND ((t_addr = '127.0.0.1')) AND t0._message_ident =tlast._ident )
WHERE tlast._ident IS NOT NULL GROUP BY t0.text,2,3,4,5,6,8,9,10
ORDER BY 7 DESC,3,4
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
