Re: Interface History Custom Report
Hi there, you have to put the to_char() in inner query.
select timestamp as hodex, sum(traffic_out) as traffic_out, sum(traffic_in) as traffic_in from ###(select to_char(from_itime(itime), 'MM-DD HH:MI') as timestamp, sum(coalesce(sentbyte, 0)) as traffic_out, sum(coalesce(rcvdbyte, 0)) as traffic_in from $log where $filter and logid_to_int(logid) not in (4, 7, 14) group by timestamp having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by timestamp desc)### t group by hodex order by hodex
FAZ bandwidth summary is to calculate total bytes transferred in certain period. When you select 1 day report period, the time interval is 1 hr. So this chart is for total volume, not bandwidth rate.
FGT bandwidth chart will show bandwidth rate in kbps instead.
If you want to see bandwidth rate in FAZ, please go to FortiView->System->Resource Usage