SELECT t1.text, t7.completion, t7.severity,
t2.address,
t3.address,
t5.iana_protocol_number,
t4.port,
t5.port,
t6.name,
t0.time, t1._message_ident
FROM Prelude_Alert AS top
LEFT JOIN Prelude_Classification AS t1 ON (top._ident = t1._message_ident)
LEFT JOIN Prelude_Address AS t2 ON (t2._parent_type = 'S' AND top._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 top._ident = t3._message_ident AND t3._parent0_index = -1 AND t3._index = -1)
LEFT JOIN Prelude_Service AS t4 ON (t4._message_ident = top._ident AND t4._parent_type='S' AND t4._parent0_index = -1)
LEFT JOIN Prelude_Service AS t5 ON (t5._message_ident = top._ident AND t5._parent_type='T' AND t5._parent0_index = -1)
LEFT JOIN Prelude_Analyzer AS t6 ON (t6._message_ident = top._ident AND t6._parent_type = 'A' AND t6._index = -1)
LEFT JOIN Prelude_Impact AS t7 ON (t7._message_ident = top._ident)
LEFT JOIN Prelude_CreateTime AS t0 ON (t0._message_ident = top._ident AND t0._parent_type = 'A')
WHERE t1.text = 'Admin login failed' AND t0.time >= '2005-12-14 16:26:11.0' AND t0.time <= '2005-12-16 11:58:06.0' AND t2.address IS NULL AND t3.address = '127.0.0.1' GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 ORDER BY 8 DESC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
