Skip to main content
RobertNi
RobertNi
New Member
March 12, 2020
Question

report total amount of users on vpn

  • March 12, 2020
  • 2 replies
  • 15059 views

hi, I want to create a report to send me each morning about the day before (N Day) amount of VPN users.

currently, it gives me each user on its own and the details but I want to simplify the results and just know how many users connected yesterday? I am new with the analyzer as you can see, so a step by step, if someone can help me, would be great!

    2 replies

    Phil_Stevens
    Phil_Stevens
    Visitor III
    March 24, 2020

    I'm in the same boat. Could do with a report of the maximum concurrent number of users connected to the SSL VPN per day. If anyone has any ideas that would be great

    JG67130
    JG67130
    New Member
    March 24, 2020

    I'm also interested in this. I managed to create a custom Dataset with the following query:

    SELECT COUNT(DISTINCT(UPPER(`user`))) FROM $log WHERE $filter AND `subtype`='vpn' AND `tunneltype`='ssl-web' AND `action`='tunnel-down'

     

    When I test this dataset, I get the right answer (great!). But when I try to add the result in a report, I always get the following message in the report: "No matching log data for this report". I have another Dataset which gives me the list of all VPN-SSL connections that occured during the specified timeperiod which is working great, so I can easily work this list in Excel to get the answer by suppressing duplicate entries, but this is very strange. If anyone can help me with this, I'm interested !

     

    kbar44
    kbar44
    New Member
    April 3, 2020

    Hi I have the same problem. I need report that shows number of unique users connected to ssl vpn per day for some period of time. Example for 7 days should be like this: date       count 2020-03-31 250 2020-03-30 234 2020-03-29 111 2020-03-28 99 2020-03-27 244 2020-03-26 200 2020-03-25 189 I create dataset like this: select to_timestamp(itime)::date as date, count(distinct `user`) from $log where $filter and (tunneltype = 'ssl-tunnel' or tunneltype = 'ssl-web') and `user` != 'N/A' group by date When I do test dateset it return data like this: date     count 2020-03-27     256 2020-03-28     13 2020-03-29     27 2020-03-30     251 2020-03-31     241 2020-04-01     253 2020-04-02     219 I create 3 types of charts for this data set bar, line andt table. When I try to add the result in a report, I get the following message in the report: "No matching log data for this report" for line and table type. Bar type of chart is ok. I don't know why.

    best regards

     

    abelio
    SuperUser
    abelio
    SuperUser
    April 3, 2020

    Hi,

    try modifying your chart using:

    chart type: table

    data bindings with table type 'ranked'

     

    I did and obtained the results you're looking for

    Terms & ConditionsAccessibility statement