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
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,
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