SELECT text AS "Tipo de mensaje" ,
CASE WHEN (completion = 'succeeded' OR completion IS NULL) THEN TRUE ELSE FALSE END AS "Completado" ,
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 '127.0.0.1' ELSE t_addr END AS "IP Destino" ,
CASE WHEN prot IS NULL THEN 0 ELSE prot END AS "Protocolo" ,
CASE WHEN MIN(s_port) IS NULL THEN 0 ELSE MIN(s_port) END AS "Puerto Orig." ,
CASE WHEN port IS NULL THEN 0 ELSE port END AS "Puerto Dest." ,
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, t7.completion, t5.iana_protocol_number AS prot, t5.port, MIN(t4.port) as s_port
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,Prelude_Service AS t5,Prelude_Service AS t4
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._message_ident = t0._message_ident
AND t1.text = 'Admin login failed'
AND t2._index = 0 AND t2._parent_type = 'S' AND t2._message_ident = t0._message_ident
AND t2.address = '192.168.100.61'
AND t3._index = 0 AND t3._parent_type = 'T' AND t3._message_ident = t0._message_ident
AND t3.address = '127.0.0.1'
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
AND t5._parent_type = 'T'
AND t5._message_ident = t0._message_ident
AND t4._parent_type = 'S'
AND t4._message_ident = t0._message_ident
GROUP BY 1, 2, 3, 4, 5, 6,7, 8,9,10,11
) AS t0 GROUP BY t0.text,2,3,4,5,6,8,9,10 ORDER BY 12 DESC,3,4
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
