What is the purpose of an SQL SELECT query in FortiAnalyzer?

The purpose of an SQL SELECT query in FortiAnalyzer is fundamentally to retrieve specific read-only data from the database. This is a critical function, as it allows users to access important logging and reporting data stored within the FortiAnalyzer system. By using SELECT queries, users can filter and specify exactly what information they need from the database, such as logs, statistics, or other relevant data drawn from the myriad of recorded events. This capability is essential for generating insights, conducting investigations, and performing analysis based on accumulated logs, without altering the actual data in the database.