TOP WEB SITES+CATEGORY FOR MOST ACTIVE USERS

Forum|Forum|10 years ago
June 2, 2016
5 replies
9994 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

report.JPG

hzhao_FTNT

Staff

Hi there,

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

Regards,

hz

c_martinezAuthor

New Member

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

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

chart_setting.jpg

Sign up

Login with SSO

Login to the community

Login with SSO