Skip to main content
c_martinez
c_martinez
New Member
June 2, 2016
Question

TOP WEB SITES+CATEGORY FOR MOST ACTIVE USERS

  • June 2, 2016
  • 1 reply
  • 9974 views

Hello,

 

There was a default report in the previous version of fortianalyser  that was very useful .Named: Top Web sites+category for most active users. In the version 5.2 doesn't exist anymore. Can anyone help me to re-create the report?

 

Screenshot attached.

 

 

Thanks in advance,

Carmina

    1 reply

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    June 2, 2016

    Hi there,

     

    We have a similar predefined report "Top 20 Category and Websites (Session)" in 5.2.

     

    Regards,

    hz

    c_martinez
    c_martinezAuthor
    New Member
    June 2, 2016

    Hi,

     

    This report isn't in my list. Could you please send the dataset for re-creating or anything I can import?

     

    Thanks & Regards,

    CM

    hzhao_FTNT
    Staff
    hzhao_FTNT
    Staff
    June 2, 2016

    That report should be in "Web" folder, if you can not find it, you can clone one from "Default Templates" folder. Anyway, I include dataset and chart setting here, just in case. 

     

    select website, catdesc, sum(hits) as hits from (###(select hostname as website, catdesc, count(*) as hits from $log-traffic where $filter and hostname is not null and logid_to_int(logid) not in (4, 7, 14) and utmevent in ('webfilter', 'banned-word', 'web-content', 'command-block', 'script-filter') group by website, catdesc order by hits desc)### union all ###(select hostname as website, catdesc, count(*) as hits from $log-webfilter where $filter and hostname is not null and (eventtype is null or logver>=52) group by website, catdesc order by hits desc)###) t group by website, catdesc order by hits desc

     

    regards,

    HZ

    Terms & ConditionsAccessibility statement