SQL Log Database Query Technote

FortiAnalyzer units support local PostgreSQL and remote MySQL databases for storage of log tables. FortiGate units with hard disks support local SQLite databases for storage of log tables. This document describes how to write your own SQL query statements to create custom datasets and describes the fields in each type of log table to assist in writing SQL queries.