Skip to main content
CorneJvV
New Member
February 10, 2015
Question

Bandwidth per hour per VDOM

  • February 10, 2015
  • 3 replies
  • 7731 views

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

    3 replies

    hzhao_FTNT
    Staff
    Staff
    February 10, 2015

    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
    CorneJvVAuthor
    New Member
    February 11, 2015

    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
    Staff
    Staff
    February 11, 2015

    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
    CorneJvVAuthor
    New Member
    February 19, 2015

    Sorry for the late reply.

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

    Thank you so much.