how can i execute sql queries with a prtg sensor and save the query result?
Modified on 2025-06-10 21:58:54 +0200
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
Important: We no longer maintain this article. The information might be out of date.
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?
Article Comments
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!!
Oct, 2016 - Permalink
Well, the tutorial is rather new :)
Oct, 2016 - Permalink
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.
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.
Oct, 2016 - Permalink