Skip to main content
CHXGVA
New Member
May 8, 2020
Question

FAZ - Dataset VPN_SSL_USER_DURATION - Sql Bug when S_Time = E_Time

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.  
    Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
    Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT