DOCUMENT LIBRARY

FortiGate / FortiOS

SQL Query Documentation

Home FortiAnalyzer 7.6.0 SQL Query Documentation

7.6.0

Analyzing a query

Analyzing a query

When creating or editing a dataset, click Analyze Query to review details of the dataset query.

SQL Validation Result		The validation results of the query.
SQL Query Information
Original Query		The original input query.
Transformed SQL Query		The whole dataset query after transformation. If the original query has hcache signs “`###(`“ and “`)###`”, then no transformation is needed for the original query. If the original query has a log macro (for example, `$log`, `$log-traffic`) and does not have hcache signs “`###(`“ and “`)###`”, the whole original query will be the hcache query. The report engine will automatically add hcache signs and the rest of the transformed query outside the hcache part for this dataset.
Hcache Query List		Every hcache query in this dataset will be listed.
	Hcache SQL Query	The hcache query that is used for creating hcache tables.
	Hcache Aggregation	The query used in hcache aggregation.

Previous

Next

Analyzing a query

Analyzing a query

When creating or editing a dataset, click Analyze Query to review details of the dataset query.

SQL Validation Result		The validation results of the query.
SQL Query Information
Original Query		The original input query.
Transformed SQL Query		The whole dataset query after transformation. If the original query has hcache signs “`###(`“ and “`)###`”, then no transformation is needed for the original query. If the original query has a log macro (for example, `$log`, `$log-traffic`) and does not have hcache signs “`###(`“ and “`)###`”, the whole original query will be the hcache query. The report engine will automatically add hcache signs and the rest of the transformed query outside the hcache part for this dataset.
Hcache Query List		Every hcache query in this dataset will be listed.
	Hcache SQL Query	The hcache query that is used for creating hcache tables.
	Hcache Aggregation	The query used in hcache aggregation.

Previous

Next