VPN IPSEC DataSET (VPN Report)

[mohammada]

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

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

[frankcaffrey]

which VPN are u using right now?

[mohammada]

IPSec using Forti Client 

[mohammada]

IPSec 

[frankcaffrey]

than I'm afraid i can't help