SELECT iana_protocol_number AS "Nombre" , iana_protocol_number AS "Protocolo" , COUNT(_ident) AS "Alertas" ,
ROUND( 100.0*COUNT(_ident)/130,5) AS "%" , MIN(time) AS "Desde" , MAX(time) AS "Hasta" FROM
(
SELECT * FROM
(
SELECT CASE WHEN t4.iana_protocol_number IS NULL THEN '0' ELSE t4.iana_protocol_number END AS "iana_protocol_number",
CASE WHEN t4.iana_protocol_number IS NULL THEN '0' else tlast._ident end, t0.time AT TIME ZONE 'GMT' AS "time"
FROM Prelude_Alert 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 =t4._message_ident and t7._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =t7._message_ident AND tlast._ident BETWEEN 6481 AND 16239)
GROUP BY tlast._ident,t4.iana_protocol_number,3 ORDER BY tlast._ident DESC LIMIT 9758
) AS taux
EXCEPT
SELECT * FROM
(
SELECT CASE WHEN t4.iana_protocol_number IS NULL THEN '0' ELSE t4.iana_protocol_number END AS "iana_protocol_number",
CASE WHEN t4.iana_protocol_number IS NULL THEN '0' else tlast._ident end, t0.time AT TIME ZONE 'GMT' AS "time"
FROM Prelude_Alert 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 =t4._message_ident and t7._message_ident BETWEEN 6481 AND 16239)
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident =t7._message_ident AND tlast._ident BETWEEN 6481 AND 16239)
GROUP BY tlast._ident,t4.iana_protocol_number,3 ORDER BY tlast._ident DESC LIMIT 9758
) AS taux
WHERE taux._ident IS NULL
) AS tlast
GROUP BY 1 ORDER BY 3 DESC LIMIT 25
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
