SQL tables

SQL is the database language that FortiAnalyzer uses for logging and reporting. Log data is inserted into the SQL database for log view and report generation. FortiAnalyzer uses a PostgreSQL database.

In an SQL database all information is represented as tables, and each table consists of a set of rows and columns. There are two types of tables:

• User tables, which contain information that is in the database, and
• System tables, which contain the database description.

You can use information from SQL tables to create custom datasets for use in report charts.