SELECT COUNT(cont) AS "N x (Tipo de mensaje)" ,
severity AS "Severity", s_addr AS "Source", t_addr AS "Target",a_addr AS "Probe", name AS "Sensor", MIN(t0.time) AS "FTS" , MAX(t0.time) AS "LTS"
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, t12.address AS a_addr, t6.name AS name, t0.time AT TIME ZONE 'GMT' AS time
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
WHERE t0.time >= '2006-03-21 12:50:06' AND t0.time <= '2006-03-21 13:30:52' AND t0._parent_type = 'A'
AND t0._message_ident = t1._message_ident
AND t2._parent_type = 'S' AND t2._index = 0 AND t0._message_ident = t2._message_ident
AND t3._parent_type = 'T' AND t2._index = 0 AND t0._message_ident = t3._message_ident
AND t12._parent_type = 'T' AND t12._index = 0 AND t0._message_ident = t12._message_ident
AND t6._parent_type = 'A' AND t6._index = -1 AND t6.model IS NULL AND t0._message_ident = t6._message_ident
AND t0._message_ident = t7._message_ident
GROUP BY 1,2,3,4,5,6,7,8
) AS t0
GROUP BY t0.text,2,3,4,5,6
ORDER BY 7 DESC,3,4
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
