Skip to main content
laupin
New Member
February 28, 2019
Question

Fortianalyser Report has different data than Dataset test

  • February 28, 2019
  • 1 reply
  • 3029 views

Hello,

 

I'm trying to configure a report to check how many times my user had succefully login with the VPN and when was the las time. 

This is my Dataset:

select  (`user`) as usager,

           sum((case when reason='login successfully' then 1 else 0 end)) as total, from_dtime(max(coalesce(dtime, 0))) as end_time 

from $log

where $filter and reason='login successfully' 

group by usager, total

order by total desc

 

When I ran the test dataset, I have good results, but not when I run the report for example:

 

From data test user pinla11 has been logged 6 times and last time was 27/02/2019

At the report, I have two differents entries:

pinla11 3 times  02/02/2019

pinla11 3 times  26/02/2019

 

I had try evrithing I found in the Internet, nothing work..

can anyone help me?

 

Thanks in advance..

1 reply

Amani734017
New Member
June 26, 2019

Hi Laupin, 

I have the same problem ,Can anyone help us ? 

 

Thanks .

Thought Leadership Security Summit. Outpace New Threats with AI - enhanced defense. Tuesday, Septmeber 15, 8:30 AM - 2:30 PM PT. The Golf Club at Newcastle, WA.
Virtual event | September 2026. SASE summit. The age of autonomous trust. Register here!