Hello, I've been creating and modifying templates from \webroot\reporttemplates and \webroot\reporttemplates\details in order to get reports from different switches. Now I need to get a table report on average traffic and max. traffic on those interfaces.

So far I got the report to give me the table with device, sensor, and average traffic. I also added the graph...where I can see the max (and min) average traffic from whatever period of time I want...thing is I need the max average traffic as text, so I can copy paste everything to excel.

Can anyone tell me how to get a text output for the max average traffic? Is there a way to do that?


Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Hi,

This cannot be achieved with the report function of PRTG. Nevertheless, you can use the Data Extractor Tool to export data to a MS SQL Server, or use the API to export the raw data to a csv-file and use a script to calculate the maximal average value.

Please have a look at Setup > PRTG API > Historic Data for the documentation of the API.

Best regards


Apr, 2015 - Permalink

Hi Felix, in the end I found a way to get the output I needed by modifying a different template, the one that gives a detail of the 60 highest (and lowest) traffic sensors.

I programmed it to a higher number than 60...a number I know is higher than the amount of sensors I will actually request an output for, then erased the lowest sensors part of the template, and modified the columns of the highest sensors part, leaving only the identifiers I needed, "average", "maximum", etc.

I'll try your advice too, it certainly sounds neater and easier than what I did.

Thank you very much for your response.


Apr, 2015 - Permalink

Hi, Thanks for sharing this solution with us, that's indeed advanced!


Apr, 2015 - Permalink