SELECT CASE WHEN COUNT(cont) = 21 THEN '+'||21||text ELSE COUNT(cont)||' x '||text END AS "N x (Tipo de mensaje)" ,
severity AS "Gravedad" , 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" ,
name AS "Nombre" , CASE WHEN a_addr IS NULL THEN '127.0.0.1' ELSE a_addr END AS "Terminal" , MIN(time) AS "Desde" , MAX(time) AS "Hasta"
FROM
(
SELECT t0._message_ident AS cont, t1.text AS text, t7.severity AS severity, t2.address AS s_addr, t3.address AS t_addr, t6.name AS name,
t12.address AS a_addr, t0.time AT TIME ZONE 'GMT' AS time
FROM Prelude_CreateTime AS t0,Prelude_Classification AS t1,Prelude_Address AS t2,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 t1.text = 'User login successful' AND t1._message_ident = t0._message_ident
AND t2.address = '192.168.100.61'
AND t2._index = 0 AND t2._parent_type = 'S' AND t2._message_ident = t0._message_ident
AND t3.address = '127.0.0.1'
AND t3._index = 0 AND t3._parent_type = 'T' AND t3._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
AND t7._message_ident = t0._message_ident
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8 LIMIT 21
) AS t0 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.
