Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
CorneJvV
New Contributor

Bandwidth per hour per VDOM

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

FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
4 REPLIES 4
hzhao_FTNT
Staff
Staff

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
New Contributor

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 ?

 

FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
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
New Contributor

Sorry for the late reply.

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

Thank you so much.

FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
FCNSA FortiGate 60C, 110C, 200B, 310B FortiAnalyzer 100C FortiMail 100 FortiManager 100
Labels
Top Kudoed Authors