SELECT COUNT(t0.time) AS "N", t1.text AS "Classification", CASE WHEN t2.address IS NULL AND t3.address IS NULL THEN 'n/a' ELSE t2.address END AS "Source Addr", t3.address AS "Target Addr", t6.name AS "Sensor",
to_char(MAX(t0.time), 'YY-MM-DD HH24:MI') AS "LTS", to_char(MAX(t0.time)-MIN(t0.time), 'DD "Dias" HH24 "Horas" MI "Minutos" SS "Segundos"') AS "During", t7.severity AS "Severity"
FROM Prelude_Classification AS t1
LEFT JOIN Prelude_Address AS t2 ON (t2._parent_type = 'S' AND t1._message_ident = t2._message_ident AND t2._parent0_index = -1 AND t2._index = -1)
LEFT JOIN Prelude_Address AS t3 ON (t3._parent_type = 'T' AND t1._message_ident = t3._message_ident AND t3._parent0_index = -1 AND t3._index = -1)
LEFT JOIN Prelude_Service AS t4 ON (t4._message_ident = t1._message_ident AND t4._parent_type='S' AND t4._parent0_index = -1)
LEFT JOIN Prelude_Service AS t5 ON (t5._message_ident = t1._message_ident AND t5._parent_type='T' AND t5._parent0_index = -1)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident = t1._message_ident AND t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = t1._message_ident)
LEFT JOIN Prelude_CreateTime AS t0 ON (t0._message_ident = t1._message_ident AND t0._parent_type = 'A')
GROUP BY 2, 3, 4, 5, 8 ORDER BY 7 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
