Skip to main content
kavehfortinet2018
kavehfortinet2018
New Member
February 20, 2018
Question

FortiAnalyzer custom reporting feature

  • February 20, 2018
  • 1 reply
  • 3963 views

Dear all

 

Is it possible to do the below reports with forti analyzer ?

Combine reports and consolidate reports ( such as user browsing activity during  working hours ( 9am  to 1pm) and non-working hours (1pm to 2pm , 6pm to 9am) daily , weekly and monthly  )including top 50 user, top 50 web sites users visit . total bandwidth used by users.Is it possible to have scheduled reports like during certain duration (1 pm to 2pm) ? 

Regards

    1 reply

    RobertReynolds
    RobertReynolds
    New Member
    February 20, 2018

    This dataset will give you the web browsing time of day results:

     

    select hostname, url, catdesc,  to_char(from_dtime("dtime"), 'HH24:MI' ) as hour from $log where $filter  and  to_char(from_dtime("dtime"), 'HH24:MI') between '9:00'  and '13:00' and hostname is not null order by hour;

    I've not figured out how to have different time periods in the same report as that parameter is set on the report setting itself. Interested to hear if it can be done, as Ive had a lot of requests for showing 'trends' over time.

    Terms & ConditionsAccessibility statement