Fortinet
NSE8_812 · Question #134
You are asked to write a FortiAnalyzer report that lists the session that has consumed the most bandwidth. You are required to include the source IP, destination IP, application, application…
The correct answer is C. select from_time(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum(coalesce('sentbyte', 0)+coalesce('rcvbyte', 0)) as bandwidth from $log where $filter LIMIT 1. See the full explanation below for the reasoning.
Question
You are asked to write a FortiAnalyzer report that lists the session that has consumed the most bandwidth. You are required to include the source IP, destination IP, application, application category, hostname, and total bandwidth consumed.
Which dataset meets these requirements?
Options
- Aselect from_time(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum(coalesce('sentbyte', 0)+coalesce('rcvbyte', 0)) as bandwidth from $log where $filter LIMIT 1
- Bselect from_time(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum(coalesce('sentbyte', 0)+coalesce('rcvbyte', 0)) as bandwidth from $log where $filter LIMIT 1
- Cselect from_time(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum(coalesce('sentbyte', 0)+coalesce('rcvbyte', 0)) as bandwidth from $log where $filter LIMIT 1
- Dselect from_time(itime) as timestamp, srcname, dstip, app, appcat, hostname, sum(coalesce('sentbyte', 0)+coalesce('rcvbyte', 0)) as bandwidth from $log where $filter LIMIT 1
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- C82% (28)
- D9% (3)
Community Discussion
No community discussion yet for this question.