SELECT iana_protocol_number as "Protocolo", cont as "Alertas", ROUND(100.0*cont/130,5) as "%", tfts as "Desde", tlts as "Hasta" FROM
(
SELECT CASE WHEN t4.iana_protocol_number IS NULL THEN '0' ELSE t4.iana_protocol_number END AS "iana_protocol_number",
count(tlast._ident) as "cont", MIN(TIME) as "tfts", MAX(time) 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_Service AS t4 ON (t4._parent0_index = -1 AND t4._parent_type='T' AND t4._message_ident =top._ident AND t4._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 tlast._ident =top._ident AND tlast._ident BETWEEN 6481 AND 16239)
GROUP BY 1 ORDER BY 2 DESC LIMIT 9758
) AS taux
WHERE taux.cont != 0
GROUP BY 1,2,4,5
ORDER BY 3 DESC LIMIT 25
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
