What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

SQL Data Extractor

Votes:

0

Wondering if anyone is using this in a production environment. I have roughly 11,000 sensors. And am struggling to get this to export to SQL?

What set are you using to get this done ? Thanks

database prtg sql

Created on May 7, 2015 8:01:46 PM



Best Answer

Accepted Answer

Votes:

2

This article applies as of PRTG 24

if you are looking for data extraction from PRTG to SQL / Oracle database, try the PRTG extension: PRTG Data Extractor.

There is a trial version available on the Paessler website

Main features:

  • supports PRTG Enterprise Monitor
  • export from multiple PRTG servers into 1 database
  • export to any number of DBs you need
  • export to MSSQL or Oracle (more DBMS types coming)
  • continuous automatic exporting to keep SQL data in sync
  • smart sensor filtering to automatically include new sensors in export
  • and more...

Feel free to contact the PRTG custom service team if you have any questions.

Created on Feb 12, 2020 2:57:30 PM

Last change on Feb 1, 2024 4:49:41 PM by Jacqueline Conforti [Paessler Support]



6 Replies

Votes:

0

Hi,

What exactly do you want to export?

Created on May 8, 2015 7:06:49 AM



Votes:

0

advanced reporting, say a weighted server report, we have a reporting department that writes all our reports and would be able to leverage a lot more of PRTG

Created on May 13, 2015 11:44:09 PM



Votes:

0

What exact problems do you experience? Long execution time?

Created on May 14, 2015 11:30:52 AM by Stephan Linke [Paessler Support]



Votes:

0

yeah, that's really the only issue I have, is long execution....yesterday I did a robo copy of the datastore for PRTG to a dedicated server, disabled the probe service and started it again to see if I could cut it down.......in the previous attempt I was using 4 vm servers, processing 2500 sensors and it took each one 15 hours to complete.

Created on May 14, 2015 12:28:53 PM



Votes:

0

That's actually one of the problem the tools has with larger installations. We're aware of it and trying to improve the extractor in the future. Although this might take a while, I'm afraid :/

Created on May 14, 2015 2:41:16 PM by Stephan Linke [Paessler Support]



Accepted Answer

Votes:

2

This article applies as of PRTG 24

if you are looking for data extraction from PRTG to SQL / Oracle database, try the PRTG extension: PRTG Data Extractor.

There is a trial version available on the Paessler website

Main features:

  • supports PRTG Enterprise Monitor
  • export from multiple PRTG servers into 1 database
  • export to any number of DBs you need
  • export to MSSQL or Oracle (more DBMS types coming)
  • continuous automatic exporting to keep SQL data in sync
  • smart sensor filtering to automatically include new sensors in export
  • and more...

Feel free to contact the PRTG custom service team if you have any questions.

Created on Feb 12, 2020 2:57:30 PM

Last change on Feb 1, 2024 4:49:41 PM by Jacqueline Conforti [Paessler Support]




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.