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? http://docs.fortinet.com/uploaded/files/2617/fortianalyzer-5.2.4-dataset-reference.pdf
A.
select from_itime(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum
(coalesce(‘sentbyte”, 0) +coalesce(‘recbyte “, 0)) as bandwidth from $log where
$filter LIMIT 1
B.
select from_itime(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum
(coalesce(‘sentbyte”, 0) +coalesce(‘recbyte“, 0)) as bandwidth from $log where
$filter LIMIT 1
C.
select from_itime(itime) as timestamp, srcip, dstip, app, appcat, hostname, sum
(coalesce(‘sentbyte”, 0) +coalesce(‘rcvdbyte“, 0)) as bandwidth from $log where
$filter LIMIT 1
D.
select from_itime(itime) as timestamp, sourceip, destip, app, appcat, hostname,
sum(coalesce(‘sentbyte’, 0)+coalesce(‘rcvdbyte“, 0)) as bandwidth from $log
where $filter LIMIT 1