SELECT t3.address, t4.port, t4.iana_protocol_name,
t3.netmask AS "Máscara de red", t8.category AS "Categoría", t13.tty AS "tty",
CASE WHEN t13.name IS NULL THEN
CASE WHEN t13.name IS NULL THEN NULL
ELSE t13.name END
ELSE CASE WHEN t13.number IS NULL THEN t13.name
ELSE t13.name||':'||t13.number END END AS "Uid",
t9.name AS "processname", t9.pid AS "process_id"
FROM Prelude_Alert AS top
LEFT JOIN Prelude_Address AS t3
ON (top._ident = 16195 AND t3._message_ident = top._ident AND t3._index != -1 AND t3._parent_type = 'T' AND t3._parent0_index = -1 )
LEFT JOIN Prelude_Service AS t4
ON (top._ident = t4._message_ident AND t4._parent_type = 'T')
LEFT JOIN Prelude_User AS t8
ON (t8._message_ident = top._ident AND t8._parent_type = 'T' AND t8._parent0_index = -1)
LEFT JOIN Prelude_UserId AS t13
ON (t13._message_ident = top._ident AND t13._parent_type = 'T' AND t13._parent0_index = -1 AND t13._index = -1)
LEFT JOIN Prelude_Process AS t9 ON (t9._message_ident = top._ident AND t9._parent0_index = -1 AND t9._parent_type = 'T')
LEFT JOIN Prelude_Alert AS tlast ON (tlast._ident = top._ident)
WHERE t3._message_ident = 16195 AND t3._parent0_index = -1 AND t3._parent_type = 'T' and t3._index != -1
GROUP BY 1,2,3,4,5,6,7,8,9,t3._index ORDER BY t3._index ASC
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
