SELECT a_addr AS "Nombre" , a_addr AS "Terminal" , cont AS "Alertas" , ROUND( 100.0*cont/130,5) AS "%" , tfts AS "Desde" , tlts AS "Hasta"
FROM
(
SELECT CASE WHEN t12.address IS NULL THEN '127.0.0.1' ELSE t12.address END AS a_addr, COUNT(tlast._ident) AS "cont" ,
MIN(t0.time AT TIME ZONE 'GMT' ) AS "tfts" , MAX(t0.time AT TIME ZONE 'GMT' ) AS "tlts"
FROM
(
SELECT t._ident FROM prelude_alert as t WHERE t._ident BETWEEN 6481 AND 16239
) AS top
LEFT JOIN Prelude_DetectTime AS t0
ON (t0._message_ident =top._ident AND t0._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Address AS t12 ON (t12._index = -1 AND t12._parent_type = 'A' AND t12._parent0_index = -1 AND t12._message_ident =top._ident
AND t12._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Impact AS t7 ON ((t7.severity = 'high') AND t7._message_ident =top._ident AND t7._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Alert AS tlast ON ((t7.severity = 'high') AND (t12.address IS NULL) AND tlast._ident =top._ident AND tlast._ident BETWEEN 6481 AND 16239)
GROUP BY 1 ORDER BY 2 DESC LIMIT 9758
) AS tlast
WHERE tlast.cont != 0
GROUP BY 1,2,3,5,6
ORDER BY 3 DESC LIMIT 25
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
