PRTG Data Extractor
Important note: The PRTG Data Extractor has been discontinued!
There is no further development planned for this freeware tool. You can still use it
but we do not provide support for the PRTG Data Extractor anymore.
Extended Report Generation
for PRTG Network Monitor
The PRTG Data Extractor can retrieve raw monitoring data from the internal database of your PRTG server and write this data into a Microsoft SQL database. Set up a reporting software that can access the data in the SQL database and you will be able to generate your own, individually created monitoring data reports with your favorite reporting tool (such as Crystal Reports, or others).
If you have higher demands on your reports than the available standard reports in PRTG provide, then you should definitely try out the Data Extractor in combination with a suitable reporting server.
The Data Extractor writes data from the PRTG database to an SQL database so you can
- use any reporting system you like, already know, or have the developers for
- to create your monitoring data reports in a completely individual way.
- This way, you get much more report options than every report feature integrated into PRTG could have!
How Does It Work and What Do You Need?
The data of PRTG's internal database is optimized for best performance and you cannot access it directly. The PRTG Data Extractor transfers data from the PRTG database via the PRTG API into an SQL server database. This makes it possible that you apply a reporting tool that processes the SQL data and generates custom reports specific to your needs.
What you need for this is the following:
- PRTG Core Server version 14.3.11 or later (we recommend an additional PRTG installation for data extraction, for example, the freeware edition, on which you run a copy of your live system)
- Microsoft SQL Server (recommended: SQL Server 2012)
- Report generation software (for example, Crystal Reports, SQL Server Reporting Services, SAP BusinessObjects)
- At least basic knowledge about and experience with databases and reporting systems
For more details about the Data Extractor and its setup and requirements, we recommend that you have a look at the manual that comes with it. There you can also find instructions for the demo reports which we deliver with the Data Extractor to demonstrate its usage.
Note: The PRTG Data Extractor has been discontinued. Please understand that we do not offer support regarding issues when extracting your data, nor in creating reports using third-party software.
Download the ZIP file (see link below), unzip all files into a folder of your choice, and run the DataExtractor.exe file to start the Data Extractor.
Please download the Data Extractor below. For more details about the Data Extractor, please see the manual.
Hi and welcome to the PRTG for Android app tutorial. The PRTG for Android app is installed just like any other app would be from the App Store.
And once installed you can click on the shortcut on your desktop. Once you have an account added you'll be able to see the device to review in this view that you see here. You gonna go to a specific sensor or channel you just click on the device and click through to the channel specifically.
You can see the different sensors for this device and if you wanna see the graph the data for anyone specifically you can click on that as well. Once you get to the sensor you can see other statistical information and you can see the PRTG interface, you can see your gauges and you can see the values for each one of them.
The size you looking at the sensor in PRTG for Android at the very bottom you can see the buttons for the different graphs for the sensor. If you click on the buttons it will show you the graph in full screen view. The next thing that you can do with the PRTG for Android app is you can actually set the priority for each sensor and if it's a favorite or not.
So once you have your sensors favored, you can actually go to the menu and click on your favorite sensors and it will show up right there. Also the menu you can click on the actual red sensors in your PRTG installation if you wanna see which senses are actually an error state.
If you have a red sensor that's in an error state and you need to acknowledge it positive anything else you can do it from the menu as well. You can click on the acknowledge checkbox and acknowledge it forever long you need to or you can check the POS box for the same thing. You can also give it a definition as to why.
To the PRTG for Android app you can also see the maps. You click on a menu and then go to maps you can see all the various maps that you have set up and showing them that you want on your Android phone. Here's one that we've customized for the Android phone itself. Here you can see our entire biosphere infrastructure with the CPU usage of the actual VMware device itself, along with the ping the RDP, the Disc Free, Pagefile usage and so on.
Again using the menu you can go down and go to your tickets. Here you can see the different tickets that are assigned to different people and if you want to you can click on them and add it and assign them as well.
Something else that is available in the PRTG for Android app are the notification settings. Here you can actually go in and say when you want to have an alarm actually set off on your Android device or not and it's going to blink the LED and so on and so forth. You can also set up notifications for tickets.
With the PRTG for Android app you can connect multiple instances of PRTG as well. Here you can see that we have two setups to add an account: All you have to do is click on Add Account, input the information and you have the new installation up.
Here you can see how we click on it, here's all the information for the other one. You go to your side menu and then click on the other instance. Then you go to somewhere what you have the very beginning at the tutorial. One of the unique things about the PRTG for Android app is that also includes some network tools.
You go to your side menu, click on network tools—you can see the various tools that are available. So you can while you're on the go you can do things like Ping, Traceroute, DNS lookup in a Raw HTTP requests.
Another feature of the Android app is that you can go to channel specifically for any sensor you can hold down, long click it and so use this channel as a widget. Once you have set that up your widget channel you can go to your Widgets and pull it directly on to your Android's desktop.
So the other widgets that we have there you can display all the PRTG alarms in this way a specific channel value as a small box or you can use the channel gauge like we should before. There is also a global status widget as well. For the PRTG for Android tablet application there's one extra feature that isn't on the the phone version—it's called the dashboard! You could click on the dashboard you to display a very statistics directly from PRTG signal but I look at the wall or something like that and get all the information that is important to the installation.
The last feature for the PRTG for Android app is that we also included the sunscreen. This is similar to the dashboard but if you have the device or Android device amounted to a docking station or something like that you can turn on the sunscreen for the device and this will pop up and show you the status for PRTG.
We hope that you enjoyed the PRTG for Android app that we've built for you and hope that helps you on your network more effectively and seamlessly.
Thanks for your time.
Development of the Data Extractor has been discontinued! We still provide this Freeware program for Paessler customers as a basis for extended reporting for PRTG, but we do not offer any support for the Data Extractor.
Please also understand that we cannot provide recommendations nor support for your database and reporting server setup. Also we cannot give any help for SQL queries. Please have a look at our demo reports and, if you need further assistance, contact the support of your reporting tool.
- V0.1 (May 12th 2015): Maintenance release
- V0.1 (January 30th 2015): Initial release for public beta testing