Skip to main content
mohammada
New Member
March 20, 2016
Question

VPN IPSEC DataSET (VPN Report)

  • March 20, 2016
  • 2 replies
  • 4626 views

Hello ,

 

with reference to my customized VPN report below

please be informed that i have restricted the VPN access ( IPSEC ) with a MAC Address , so i need your help to let those mac addresses to be appeared in below report as a separate column ...  is that possible ?! if yes , would you mind please provide me with its Dataset ?!

 

appreciate your support ..  Thanks in advance 

=======================================================================

select coalesce(nullifna(`xauthuser`), nullifna(`user`)) as User_Name, remip, coalesce(nullifna(tunneltype||' - '||vpntunnel), tunneltype) as VPN_Tunnel, tunnelid, to_timestamp(min(itime)) as Logon, to_timestamp(max(itime)) as Logoff, max(itime)-min(itime) as Time_duration, max(rcvdbyte) as rcvd, max(sentbyte) as sent, max(rcvdbyte+sentbyte) as Bandwidth from $log where $filter and subtype='vpn' and (tunneltype = 'ssl-tunnel' or tunneltype='ipsec') and action <> 'tunnel-stats' group by User_Name,remip, VPN_Tunnel, tunnelid order by logon DESC

========================================================================

    2 replies

    frankcaffrey
    New Member
    March 21, 2016

    which VPN are u using right now?

    mohammada
    mohammadaAuthor
    New Member
    March 21, 2016

    IPSec using Forti Client 

    frankcaffrey
    New Member
    March 24, 2016

    than I'm afraid i can't help