New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


How do i change the query of an SQL sensor?

Votes:

0

Your Vote:

Up

Down

I created an SQL sensor (Microsoft SQL v2). as it worked, i recognized a little mistake resulting in "wrong" output. I modified the query, saved the file again in the original place, but the sensor still uses the "original" query (as i could confirm by logging the query details). Even rebooting the whole probe did not change anything.

So my question is: How can i modify the underlying query of an SQL sensor without re-creating the whole sensor (with all its settings) ?

edit query sql

Created on Jul 24, 2018 12:47:51 PM by  Arnold Schommer (0) 1



5 Replies

Votes:

0

Your Vote:

Up

Down

Dear Arnold,

does that sensor run on a remote probe? In this case, the .sql file has to be changed on that computer.

Created on Jul 24, 2018 8:37:29 PM by  Arne Seifert [Paessler Support]



Votes:

0

Your Vote:

Up

Down

No, there is just one local probe.

Created on Jul 25, 2018 6:55:50 AM by  Arnold Schommer (0) 1



Votes:

0

Your Vote:

Up

Down

Dear Arnold,

if the old file is overwritten, the sensor has to use the current one, as the SQL statement is not cached. For analysis, please create a second sensor with the overwritten .sql file. Do you get the old, or the current version?

Created on Jul 25, 2018 6:28:29 PM by  Arne Seifert [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Is there a way to change the SQL Query File using the API?

Created on Feb 26, 2019 10:36:36 PM by  bdeitz (0)



Votes:

0

Your Vote:

Up

Down

Setting the executed .sql-file with an API call is not supported. Please set this the only supported way by creating the sensor by hand.

Created on Mar 5, 2019 1:18:09 PM by  Torsten Lindner [Paessler Support]



Please log in or register to enter your reply.


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.