SELECT CASE WHEN COUNT(t0._message_ident) = 21 THEN '+'||21||text ELSE COUNT(t0._message_ident)||' x '||text END AS "N x (Tipo de mensaje)" ,
CASE WHEN (s_addr) IS NULL OR s_addr = ' ' THEN '127.0.0.1' ELSE s_addr END AS "IP Origen" ,
CASE WHEN t_addr IS NULL THEN (SELECT path FROM Prelude_File AS t8 LEFT JOIN Prelude_Alert AS top ON (t8._message_ident = top._ident) WHERE t8._parent0_index = -1 AND t8._index = -1 GROUP BY 1) ELSE t_addr END AS "IP Destino" ,
MAX(time) AS "Hasta"
FROM
(
SELECT t0._message_ident, t1.text AS text, t3.address AS t_addr,t0.time AT TIME ZONE 'GMT' AS time
FROM Prelude_CreateTime AS t0,Prelude_Classification AS t1,Prelude_Address AS t3,Prelude_Analyzer AS t6,Prelude_Impact AS t7,
Prelude_Address AS t12
WHERE (t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52') AND t0._parent_type = 'A'
AND t3._index = 0 AND t3._parent_type = 'T' AND t3._message_ident = t0._message_ident
GROUP BY 1, 2, 3, 4
) AS t0
LEFT JOIN
(SELECT _message_ident, address as s_addr FROM
(SELECT t2._message_ident,t2.address,t0.time FROM Prelude_Address AS t2,Prelude_CreateTime AS t0
WHERE t2._parent_type = 'S' and t2._message_ident = t0._message_ident AND t2._index = 0
AND t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52' AND t0._parent_type = 'A' GROUP BY 1,2,3) AS t2) as t2 ON (t2._message_ident = t0._message_ident)
GROUP BY t0.text,2,3,4,5,6 ORDER BY 8 DESC,3,4
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
