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!
I'm also interested in this. I managed to create a custom Dataset with the following query:
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 !
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:
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:
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.
SELECT $flex_datetime(timestamp) AS hodex,
SELECT $flex_timestamp AS timestamp,`user`
AND (tunneltype = 'ssl-tunnel'
OR tunneltype = 'ssl-web')
AND `user` != 'N/A'
GROUP BY timestamp,`user`)### t
GROUP BY hodex
order by hodex
But, in my page of dataset where will make test with custom filter with more of two days the result is total sum in the each day. Instead where make with one or two days my result is amount users per hour.
My FortiAnalyzer is version 6.2.3 and not test in previous version.