How can I extract sensor uptime data from PRTG?

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

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