SELECT classf AS "Tipo de mensaje" , sev AS "Gravedad" ,
CASE WHEN (compl = 'succeeded' OR compl IS NULL) THEN TRUE ELSE FALSE END AS "Completado" ,
CASE WHEN (s_addr IS NULL) THEN CASE WHEN t_addr IS NULL THEN 'n/a' ELSE '127.0.0.1' END WHEN (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" ,
tim AS "Fecha" ,
_ident AS "Id mensaje"
FROM (select top._ident AS _ident from prelude_alert AS top order by top._ident desc limit 20)
AS top
left join (select to_timestamp(cast(t0.time AS text)||'.'||cast(t0.usec AS text),'YYYY-MM-DD HH24:MI:SS.US') AS "tim", t0._message_ident from prelude_createtime AS t0 where t0._parent_type='A' order by t0._message_ident desc limit 20)
AS t0 on (top._ident = t0._message_ident)
left join (select t1.text AS "classf",t1._message_ident from prelude_classification AS t1 order by t1._message_ident desc limit 20)
AS t1 on (top._ident = t1._message_ident)
left join (select t7.severity AS "sev",t7.completion AS "compl", t7._message_ident from prelude_impact AS t7 order by t7._message_ident desc limit 20)
AS t7 on (top._ident = t7._message_ident)
left join (select t2.address AS "s_addr",t2._message_ident from prelude_address AS t2 where _parent0_index = 0 and _index = 0 and _parent_type = 'S' order by t2._message_ident desc limit 20)
AS t2 on (top._ident = t2._message_ident)
left join (select t3.address AS "t_addr",t3._message_ident from prelude_address AS t3 where _parent0_index = 0 and _index = 0 and _parent_type = 'T' order by t3._message_ident desc limit 20)
AS t3 on (top._ident = t3._message_ident)
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
