Troubleshooting Tip: FortiAnalyzer Application Report shows empty result, however FortiAnalyzer have Application logs

Below is the scenario: 

1. At FortiAnalyzer, check application logs.

At FortiAnalyzer, go to Log View -> Logs -> Fortinet Logs -> Security: Application Control.

2. At FortiAnalyer, the report shows an empty result.

3. At FortiAnalyzer, copy the Chart Library name.

At FortiAnalyzer, go to Reports -> Report Definitions -> All Reports -> Edit Report -> Edit Table -> Copy for the Chart Library name.

4. At FortiAnalyzer, go to the copied Chart Library, then copy the Database name.

At FortiAnalyzer, go to Reports -> Report Definitions -> Chart Library -> Edit the copied Chart Library -> Copy for the Dataset name.

5. At FortiAnalyzer, go for the copied Database and check for SQL information.

In this scenario:

• Chart Library name: Top 10 Interested Apps by Bandwidth.
• Dataset name: Top-Interested-Apps-By-Bandwidth.

Inside the SQL information for (Top-Interested-Apps-By-Bandwidth) Database, it is possible to notice that the Dataset is only focused on these 4 Application Categories:

• P2P.
• Storage.Backup.
• File.Sharing.
• Video/Audio.

6. At FortiAnalyzer, after getting related Application logs, and report can show information.