New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

150.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


How can I extract sensor uptime data from PRTG?

Votes:

0

Your Vote:

Up

Down

Is it possible to query for uptime data on PRTG sensors and export this information directly Excel?

api custom-script-exe excel export prtg sensor tags

Created on Mar 23, 2016 2:46:39 PM by  LordPupazz (160) 2 2



1 Reply

Accepted Answer

Votes:

11

Your Vote:

Up

Down

If you have a requirement to frequently obtain uptime data from any sensors you have configured in PRTG, you can obtain that information using the APIs built into PRTG however if you need to get information for a large number of sensors, this can be quite time consuming.

To meet just such a requirement I wrote this uptime data extractor which can be downloaded from the link below:

http://www.radionowhere.org.uk/software/prtg/prtguptimedataextractor.zip

The application runs on Windows 7/8.1 and Server 2008R2 and 2012R2. The only requirements are the Microsoft .Net Framework 4.0 and network access to your PRTG server. You will also need to tag any sensors you may want to download. The application is easy to set up:

1. Extract the ZIP to a suitable folder 2. If you have tags you look for frequently, open and edit the tags.ini file, putting the friendly name followed by the tag name, separated by a semicolon. There is an example entry in the file to show you how to format it. 3. Open the server.ini file and put in the http/https link to your PRTG server. This only needs to be the FQDN of the server, so https://prtg.mydomain.com/ for example 4. Start the tool and fill in the main form, including your PRTG user name and passhash, entering a sensor tag or choosing a common search. Start and end times can also be configured, and the number of sensors to download can be limited. 5. Click the Download button and wait for the results 6. The Excel icon will export results to MS Excel, if it is installed

PRTG Update Data Extractor - Main Screen PRTG Update Data Extractor - Main Screen with example config PRTG Update Data Extractor - Main Screen with search running PRTG Update Data Extractor - Main Screen showing completed search

If you have any comments or suggestions, please feel free to let me know.

Created on Mar 24, 2016 1:56:00 PM by  LordPupazz (160) 2 2



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.