Skip to main content
sebag
sebag
New Member
December 11, 2018
Question

FrotiAnalyzer VPN Report Detailed

  • December 11, 2018
  • 1 reply
  • 4159 views

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.

    1 reply

    sebag
    sebagAuthor
    New Member
    December 11, 2018

    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
    sebagAuthor
    New Member
    December 11, 2018

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

     

    from_dtime(dtime)

    abelio
    SuperUser
    abelio
    SuperUser
    December 11, 2018

    Hi Sebastian

    sebagari wrote:

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

     

    from_dtime(dtime)

    in FAZ time.

    Terms & ConditionsAccessibility statement