New Member

Question

Interface History Custom Report

Forum|Forum|11 years ago
January 20, 2015
7 replies
97906 views

As we all know, the status dashboard has an "Interface History" widget. I love this widget however it resets when the device is power cycled.

How would I go about creating a FortiAnalyzer report that would show the same data in the same manner (hour, day week) bandwidth in and out (MBps) See attached file for how it looks in the GUI.

The FAZ is running 5.0.x code

I know there is a dataset I need to make etc but I have no idea how to do that (databases and sql are not strong points of mine)interface_history.gif

interface_history.gif

hzhao_FTNT

Staff

Please run predefined "Bandwidth and Application report", and check the first chart "Bandwidth Summary" .

You may also need apply interface filter in Advanced Settings in order to get per-interface report.

For time intervals, please try to run report with different report period.

1.jpg

MikePruettAuthor

New Member

Thanks for the help.

That one is close, but it only shows the total bandwidth transfered (gigabytes, megabytes etc) I am more interested in the throughput bandwidth transfered (gigabits, megabits etc per second) for instance if the firewall is on a T1 the transfer tops out at 1.544 mbps..

hzhao_FTNT

Staff

Unfortunately we don't have any log field to directly reflect real-time speed, and current FAZ do not allow user to create this kind of timeline chart. If you want to see max speed by time interval in table chart, you can try below dataset:

select $flex_timescale as hodex, max(coalesce(sentbyte, 0)/duration) as traffic_out_speed, max(coalesce(rcvdbyte, 0)/duration) as traffic_in_speed from $log where $filter and logid_to_int(logid) not in (4, 7, 14) and duration!=0 group by hodex having sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0))>0 order by hodex

Ahslan

New Member

I know this thread is over two years old but I'm looking for the exact same thing. Love the "Interface History" widget and want to know if there is a FortiAnalyzer report that basically does the same thing? I'm currently running FortiAnalyzer 5.4.2

fikri

New Member

if you guys use FAZ version 5.4.2

On the resource usage you can see the bandwitdh rate. But I'm not sure the measurement in bytes /kb/mb or else.

refer to the image below, any guys have any opinion on this

hzhao_FTNT

Staff

The bandwidth rate here is in kbps, but it is not based on interface. If you are interested, I can provide a report for you to run similar chart in report.

regards,

hz

fikri

New Member

Thanks for the info. Means total interface rate ?

so you have a method to run the report base on interface base on rate?..

tux3domike

New Member

It's now 2019. Has anyone found a way in FortiAnalyzer to get this graph that appears on the Widget?

119261.png

eduardo_musumeci

New Member

Hello everyone, I've got a searchable "Dataset" that displays the information of Down, Up and Total interfaces. But I still could not display a column with the interface description. Ex: WAN1 - LINK "XYZ" In the report I only have the name of the interface and for the end user this is not acceptable. Can someone help me ?

Dataset:

select `srcintf`, sum(coalesce(`rcvdbyte`,0)) as total_recvd_bytes, sum(coalesce(`sentbyte`,0)) as total_sent_bytes, sum(coalesce(`rcvdbyte`,0)+coalesce(`sentbyte`,0)) as total_bytes from $log where $filter group by `srcintf` order by total_bytes desc

Result Image" />

adipe

New Member

2020 now same question .

Camilo76

New Member

Hello, I want to say that today, March 9, 2022, I still need that consumption report in Mbps, soon a new FortiAnalyzer will be installed in the company and it seems incredible to me that we do not have that functionality. I need the Throughput graph between a source and a destination to know the impact on a data channel. I saw somewhere that the FortiManager does show those graphs for a Traffic Shaping policy but again the Kbps values are rare... Someone from Fortinet tell us if there is progress on this?