Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset. The Log type is set to Traffic and the Time Period is set to Last 30 days. The following query is entered:

SELECT root_domain(hostname) as website, count(*) as totalnum, dstcountry FROM $log WHERE $filter and hostname is not null GROUP BY hostname, dstcountry ORDER BY session desc LIMIT 25. When the administrator tests the custom dataset, an error message is returned. Why?

Question

Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset. The Log type is set to Traffic and the Time Period is set to Last 30 days. The following query is entered:

SELECT root_domain(hostname) as website, count(*) as totalnum, dstcountry FROM $log WHERE $filter and hostname is not null GROUP BY hostname, dstcountry ORDER BY session desc LIMIT 25. When the administrator tests the custom dataset, an error message is returned. Why?

Accepted Answer

B. The database does not contain the data to make the SQL query work.

Answer

A. The clauses are not coded in the correct sequence.

Answer

C. The database columns identified in the SELECT clause belong to the Virus log type, not the Traffic log

Answer

D. The database column in the ORDER BY clause ("session") is not in the SELECT clause, and it has to

Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset. The Log type is set to Traffic and the Time Period is set to Last 30 days. The following query is entered…

Question

Options

How the community answered

Community Discussion