[FAZ] - SSLVPN query by user duration

[teixeira]

Hi All, I have a dataset that filter the time / date and total time per day of a specific user's login and logout of the SSLVPN resource. In this dataset I have five columns (user, inicio(start), fim(end), tempo_conexao (sum start and end of login) and source IP). I would like to sum all input from column tempo_conexao, does anyone have any idea how I can do this? Test of the my dataset on the attached image. Follow the dataset I'm using: SELECT `user`, TO_CHAR(TO_TIMESTAMP(`itime`-`duration`)::timestamp, 'YYYY-MM-DD HH24:MI:SS') AS Inicio, TO_CHAR(TO_TIMESTAMP(`itime`)::timestamp,  'YYYY-MM-DD HH24:MI:SS') AS Fim, TO_CHAR((`duration` || 'second')::interval, 'HH24:MI:SS') AS Tempo_Conexao, `remip` AS IP_Origem FROM $log-event WHERE $filter AND `subtype`='vpn' AND `tunneltype`='ssl-tunnel' AND `action`='tunnel-down' GROUP BY `user`, Inicio, Fim, Tempo_Conexao, IP_Origem ORDER BY Inicio ASC Best regards, EB