Refer to the exhibit. A fortiAnalyzer analyst is customizing a SQL query to use in a report. Which SQL query should the analyst run to get the expected results?

The correct answer is A. SELECT srcip AS "Source IP", dstport AS "Destination Port". The correct SQL syntax with SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses in the right order. It filters for srcip = '10.0.1.10' and orders the results by destination port descending, matching the expected output.

Reports

Question

Exhibit

Options

ASELECT srcip AS "Source IP", dstport AS "Destination Port"
BSELECT srcip AS "Source IP", dstport AS "Destination Port"
CSELECT srcip AS "Source IP", dstport AS "Destination Port"
DSELECT srcip AS "Source IP", dstport AS "Destination Port"

How the community answered

(56 responses)

A
84% (47)
B
4% (2)
C
9% (5)
D
4% (2)

Explanation

The correct SQL syntax with SELECT, FROM, WHERE, GROUP BY, and ORDER BY clauses in the right order. It filters for srcip = '10.0.1.10' and orders the results by destination port descending, matching the expected output.

Topics

#SQL query#report customization#FortiAnalyzer reports#data fields

Community Discussion

No community discussion yet for this question.

Full FCP_FAZ_AN-7.4 Practice