Bandwidth per hour per VDOM

[CorneJvV]

Hello All

Is there a report on the FortiAnalyzer that will provide me with Bandwidth per hour per VDOM.

I have 4 VDOMs plus root that connect to one External router with VDOM links.

My client would like to know which VDOM uses how much data at what hour during the day.

They are currently running Faz OS 5.0.6

[hzhao_FTNT]

Hi, we don't have predefined report to show hourly data by vdom, you have to create a custom report for hourly bandwidth, then run "Multiple Reports"(Per-Device) to get individual report for each vdom.

regards,

hz 

[CorneJvV]

Hi

Thank you for the reply.

How do I create a report to use hours ?

If I go to Advanced-> Dataset->Create New

Add Variable->itime

What should I put in the Expression and Description fields ?

[hzhao_FTNT]

On FAZ 5.0.6, pls try below dataset, log type is traffic:

select $hour_of_day as hod, devid||'('||vd||')' as vdom, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log where $filter group by hod, vdom having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by hod,bandwidth desc

Then create a ranked table chart base on this dataset,  see attached screenshot for chart config and report output.

hz

[CorneJvV]

Sorry for the late reply.

But you kind sir, are a gentleman and a scholar.

Thank you so much.