NSE 5 - FortiAnalyzer 7.6 Analyst Exam Materials - Question #18 Discussion

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? (Choose one answer)

• A. SELECT srcip AS "Source IP", dstport AS "Destination Port" ORDER BY dstport DESC GROUP BY srcip, dstport FROM $log WHERE $filter AND srcip = '10.0.1.10'
• B. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND srcip = '10.0.1.10' GROUP BY srcip, dstport ORDER BY dstport DESC
• C. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND Source IP != '10.0.1.10' GROUP BY srcip, dstport ORDER BY dstport DESC
• D. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND srcip = '10.0.1.10' ORDER BY dstport GROUP BY srcip, dstport DESC

Brave-Dump Community Votes