FrotiAnalyzer VPN Report Detailed

[sebag]

Hello,

I want to make a detailed report of all VPN connection in a time range, but I need a list with login and logout date and time and vpn tunnel.

any example of the dataset?

a list of all filed in database?

thanks.

[sebag]

Hi,

I build this query that show all the vpn up and down, but I need the event date and time, what field I shuld to use? dtime? itime? and how to convert to right format? GMT-3 in my case?

select xauthuser, vpntunnel,action,remip,assignip,tunnelid,duration,sentbyte,rcvdbyte,devname from $log where $filter and subtype='vpn' and (tunneltype like 'ipsec%' or tunneltype like 'ssl%') and action in ('tunnel-up',  'tunnel-down') and tunnelid is not null and tunnelid!=0

[sebag]

I found this function to get the date and time but in which gmt?

from_dtime(dtime)

[abelio]

Hi Sebastian

sebagari wrote:

I found this function to get the date and time but in which gmt?

from_dtime(dtime)

in FAZ time.