Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
sebag
New Contributor III

FrotiAnalyzer VPN Report Detailed

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.

3 REPLIES 3
sebag
New Contributor III

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
New Contributor III

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

 

from_dtime(dtime)

abelio
Valued Contributor

Hi Sebastian

sebagari wrote:

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

 

from_dtime(dtime)

in FAZ time.

regards




/ Abel

regards / Abel
Labels
Top Kudoed Authors