Technical Tip: How to troubleshoot empty tables in a predefined web usage report

[Nur]

Description	This article describes how to troubleshoot empty tables in a predefined Web Usage report. The report from FortiAnalyzer relies on the dataset and chart builder to enable data generation and reporting. The web usage report uses several datasets and chart builders to make data visible. This article will focus on the chart below could not generate the data. The chart could not generate the data: Top 20 Most Visited Categories. Top 50 Most Visited Sites. Top 10 Online Users. Top 10 Categories. Top 50 Sites By Browsing Time. Top 20 Categories By Bandwidth.
Scope	FortiAnalyzer.
Solution	To make the data visible from the report: Ensure the policy enables the web filter profile.  From the web filter profile used, ensure the FortiGuard category-based filter is enabled. The local categories action is enabled. By default, it is disabled. After enabling the local categories, from Log & Report -> Web Filter, ensure that the category description appears and has information. From FortiAnalyzer ensure to receive the same information as the FortiGate. Generate the web usage report from FortiAnalyzer and the data should exist from the report. Note: The important keyword for the table that generates data is *categories*. If the static URL has been used from the web filter profile, the categories will not appear in the report. The web filter log category description shows empty if a FortiGuard rating error occurs. Ensure the FortiGuard category-based filters are enabled. Ensure FortiGate has a valid Web Filter License. Restarting the URL filter daemon of FortiGate may require: diagnose test application urlfilter 99