Skip to main content
fortimos
New Member
January 12, 2019
Question

Custom SQL Query for SSL-VPN usage in the FortiAnalayzer

We want to generate a custom rapport for the SSL-VPN usage using the FortiAnalayzer.

We have one appliance dedicated to the SSL-VPN usage. All our customers are using this same appliance and each customer is in the dedicated VDOM.

We want a rapport that show to us the following information:

-        The average per month of users who used the SSL-VPN, for the previous year and for each customer (VDOM).

For this, we need a custom SQL query to be used in the Dataset. Can you please suggest such query ?

    Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
    Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.
    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