SELECT CASE WHEN COUNT(tlast._ident) = 21 THEN '+'||21||' x '||text ELSE COUNT(tlast._ident)||' x '||text END AS "N x (Tipo de mensaje)" ,
severity AS "Gravedad" , CASE WHEN (t2.address) IS NULL OR t2.address = ' ' THEN '127.0.0.1' ELSE t2.address END AS "IP Origen" ,
CASE WHEN (t0.address) IS NULL THEN '127.0.0.1' ELSE t0.address END AS "IP Destino" , t0.name AS "Nombre" ,
CASE WHEN probe IS NULL THEN '127.0.0.1' ELSE probe 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 , t1.text , t7.severity , t6.name , t12.address as probe
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
) 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 (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 (t0._message_ident =t2._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 is null and t0._message_ident =tlast._ident )
WHERE tlast._ident IS NOT NULL
GROUP BY t0.text,2,3,4,5,6
ORDER BY 7 DESC,3,4
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
