Hi folks,
I have found a small bug within the Dataset or VPN_SLL_TOP_USER_DURATION. If the S_Time and E_Time have the same values the query throws out undesired results.
I presume that this happens when a user has a failed connection but somehow the log takes the details into account.
I have modified the SQL so I have a solution. How can I bring this to Fortinets attention ? So that everyone can benefit in the next release.
In the included file you can find an amended version which excludes any records where s_time = e_time.