SQL based reports

Reports : SQL based reports

SQL based reports

If you have selected the SQL database for log storage in System > Config > SQL Database, you will configure reports based on logs from a SQL database.

Logs are the basis of all FortiAnalyzer reports and must be collected or uploaded before you can generate a report. After logs are collected or uploaded, you can then configure reports based on the default or customized chart templates. For more information on logs, see “Log & Archive”.

In most cases, the default chart templates are sufficient for report configuration. However, you can create customized chart templates by configuring the datasets to get the exact chart data you want, see “Advanced report settings”. Reports are generated based on SQL queries of log files.

A report generated from an SQL query has the following components:

• report chart template

• report filters

• graphics and language

• report schedule.


	SQL Database based reports support FortiGate, FortiClient, FortiMail, FortiWeb and syslog compatible devices.


	FortiGate, when referenced in the Web-based Manager and supporting documentation, includes FortiGate, FortiWifi, FortiGate-VM, FortiGate-One and FortiCarrier devices.

This section includes the following topics:

• Enable/disable SQL database

• Enable/disable remote SQL database

• Left & right click menu tree

• Default device reports

• Email/upload remote output

• Predefined reports

• Custom reports

• Advanced report settings

• View report layout