New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Exporting PRTG reports in CSV format

Votes:

0

Your Vote:

Up

Down

Hi, I'm new to PRTG. I'm currently extracting the reports of the sensors that I am monitoring to an excel sheet. What I'm monitoring is the total downtime of the sensor for a week (e.g. 1Day 5Hours 3Minutes 30Seconds) then I transfer this data on the excel manually to get the total downtime of the sensor.

Would it be possible to extract the PRTG reports in CSV file already? Currently, it only exports PDF files and I have to input it manually to excel.

I came across with this csvexport tool which is an add-on tool on PRTG. Would this be helpful to my situation? Also, where do I install this tool?

Hoping for your response.

Thank you very much!

Regards, Gab

csvexport pdf prtg-report

Created on Mar 18, 2020 3:17:25 AM by  gvcruz (0) 1



5 Replies

Votes:

0

Your Vote:

Up

Down

Hello there,

Which report template are you using? If you choose a report template where data files are available, it's possible to export CSV files. Please also check the "Data Files" section in the report settings. For more information on reports also see:

- https://www.paessler.com/manuals/prtg/reports_step_by_step
- https://www.paessler.com/manuals/prtg/reports_settings

Created on Mar 18, 2020 9:44:00 AM by  Timo Dambach [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Hi Timo,

Thanks for your reply. I tried the Data Table (24 H Interval) template but it seems that the csv file generated is scattered. The output is something like this:

PDF CSV: 2144,2259,2264,.. etc

Is there a way to consolidate these csv file ito one file? I only want to see the number of hours the sensors was down/up for a specific time.

Thank you very much.

Regards, Gab

Created on Apr 23, 2020 12:59:44 AM by  gvcruz (0) 1



Votes:

0

Your Vote:

Up

Down

Hi Gab,

Yes, you will receive one CSV file for every Sensor added to the report. I'm afraid this cannot be changed or summarized automatically.

Created on Apr 23, 2020 12:45:56 PM by  Timo Dambach [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Hi Timo,

Thanks for your reply. This is well noted.

Regards, Gab

Created on Apr 27, 2020 2:47:10 AM by  gvcruz (0) 1



Votes:

0

Your Vote:

Up

Down

Unfortunately PRTG exports a CSV file for each sensor, but there are other more efficient methods of obtaining reports in PRTG. There are other very functional tools to obtain more structured information for reports in PRTG. I have discover a way to obtain data in no just by sensor, but by devices or groups, getting averages in all levels

Created on Jun 9, 2020 8:53:37 PM by  ALEXIS (0)



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.