topic Re: Bandwidth Utilization Report for interface with DiagnosticsView in Firewall and Security Management

Bandwidth Utilization Report for interface (smartview monitor or diagnosticsview)

r1der — Thu, 04 Feb 2021 18:24:09 GMT

Hello everyone,

I am trying to find out if I can generate a 30 day report for Mbps usage on an external interface for justifying a speed increase.

There seems to be several ways to possibly get what I am asking, but having no luck so far.

From what I have checked so far:

SmartConsole > Logs & Monitor - I have created Views/Reports >> Widget >> Timeline >> but there doesn't appear to be a Timeline Value (Y) for this. Tried Normal Traffic (bps), Traffic Total Bytes (Sum) but those don't seem to have a way to filter by interface eth1. Seeing has there's no way to do that, I think this module is not the right way to generate this.
SmartConsole > Tunnel & User Monitoring (SmartView Monitor). I created a "new traffic view". Filtered by "Real time" - Interfaces. Targeting the gateway in question. I believe this is exactly what I need, except a 30 day report. When I go back into the properties and set it to History & Traffic History to Last Month for Time Frame, it only gives the attached list.

So not sure this will work.
cpview - I found the column I believe I need, but not sure how to extract this data, besides typing it out in an excel spreadsheet. One other option I read was to possibly setup cpviewer. Another was DiagnosticsViewer. I exported the logs, and opened it within DiagnosticsViewer. There are predefined views, which has eth1_Rx_throughput, but cannot find the Tx throughput under Explorer. I can also filter the dates I want, however I cannot find the fields I need and not sure they exist. I went through each dropdown but I don't think I can get what I am looking for automatically perhaps.

Maybe I am after the wrong thing, or looking at the wrong places? Any suggestions are appreciated.

Thank you!

Re: Bandwidth Utilization Report for interface with DiagnosticsView

Danny — Thu, 04 Feb 2021 18:18:00 GMT

First try if CPViewer gives you the result you are looking for.

If that doesn't help you we can support you getting that data out of your cpview history database in an automated way.

Re: Bandwidth Utilization Report for interface (smartview monitor or diagnosticsview)

Chris_Atkinson — Fri, 05 Feb 2021 05:23:17 GMT

SNMP monitoring of interface traffic counters (as you would do for routers / switches) is also a common solution utilizing your Tool / NMS of choice e.g. Cacti etc.

Netflow is also possible but likely overkill for the task at hand.

Re: Bandwidth Utilization Report for interface with DiagnosticsView

r1der — Fri, 05 Feb 2021 16:15:47 GMT

Thanks @Danny. I wanted to be sure it'll contain the ability for the report first before setting it up, but I just pulled the trigger and set it up

This did have the information I was looking for. It aligns up with our ISP report, I just have to convert the Mib values.
CPViewer

Re: Bandwidth Utilization Report for interface (smartview monitor or diagnosticsview)

r1der — Fri, 05 Feb 2021 16:25:53 GMT

Thanks, this will be something I will look into and test around with!

Re: Bandwidth Utilization Report for interface (smartview monitor or diagnosticsview)

Elad_Chomsky — Sun, 07 Feb 2021 12:57:07 GMT

Hi r1der,

Below are the steps to modify the DiagnosticsView configuration to see the required data:

Go to C:\Users\<Your User>\AppData\Local\DiagnosticsView\Config
Create a new XML file called CPViewDbPredefined.user.xml
It contents should be similar to C:\Program Files (x86)\CheckPoint\DiagnosticsView\Config\CPViewDbPredefined.xml :

You can add your own custom configurations to this file – All of them are based on existing cpview Tables and Axis X is always a “Timestamp”
For example in this case add this lines under the Interface category:

Those columns should now appear by default.

You can also use the “Explorer” to see the data more directly:

Select the Stat you wish to see – select the table you wish to see and in it double click on the field you wish to see – and it should open you this dialog:

Re: Bandwidth Utilization Report for interface (smartview monitor or diagnosticsview)

r1der — Tue, 09 Feb 2021 00:07:24 GMT

@Elad_Chomsky, thank you so much! Just tested this out, and this will work as well.

My only issue is I'd like to have 1 y-axis if possible. Other than that, this accomplishes the request but will need 2 separate graphs for clarity.