TOP WEB SITES+CATEGORY FOR MOST ACTIVE USERS

[c_martinez]

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

[hzhao_FTNT]

Hi there,

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

Regards,

hz

[c_martinez]

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]

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

[c_martinez]

Hi,

This is not exactly what I'm looking for.

I would like to show for each 10 top active users (by sessions) the 10 top websites visited by the user. Could you look for the report named 'Top Web Sites+Category for Most Active Users'  into a previous version of fortianalyser? Since we upgraded the version those reports are no more available.

user       web-site-visited-by user      visits-user/web-site      %-of-total-visits-for-all-users

Regards,

CM

[hzhao_FTNT]

I see, it is a drilldown chart. Unfortunately this chart is removed in 5.0.*. You have to run Web Usage Report to check chart "Top 20 Most Active Users", then apply user filter to report "Top 20 Category and Websites (Session)".

Regards,

hz