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

how can i execute sql queries with a prtg sensor and save the query result?

Votes:

0

i was watching some sql sensors in prtg and talking with a friend he told me that i can execute store procedures and sql queries and show in report the result of this query... is this true?? how can i do that?

prtg query report sql

Created on Oct 23, 2016 6:01:48 AM



3 Replies

Accepted Answer

Votes:

0

You might want to ask him ;) PRTG doesn't store messages, hence they can't be reported on. Since the SQL sensors allow displaying a message from the query, you might want to use a syslog receiver sensor to log them within PRTG. This way you can search the results. But there's no way to generate a report here as well.

Created on Oct 24, 2016 6:54:43 AM by Stephan Linke [Paessler Support]



Votes:

0

thanks for your answer! i supposed that i won't can do that! i was investigating for a long time and i didnt found anything!!

Created on Oct 24, 2016 1:06:31 PM



Votes:

0

Well, the tutorial is rather new :)

Created on Oct 24, 2016 7:04:07 PM by Stephan Linke [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.