Greetings,

I am using many queries on my SQL Server as Custom Sensors in PRTG. One of the query that executes perfectly fine on Server giving me error in PRTG as under. Any ideas why it's happening?

Incorrect syntax near the keyword 'else'. Incorrect syntax near ')'. Incorrect syntax near the keyword 'else'. Incorrect syntax near ')'. Incorrect syntax near the keyword 'else'. Incorrect syntax near ')'. Incorrect syntax near the keyword 'and'.

Article Comments

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.

Hello Maazbinmahmood,

Please log onto the PRTG host and manually execute the sensor which is located in the installation directory of PRTG:

C:\Program Files (x86)\PRTG Network Monitor\Sensor System\SQLv2.exe

Here you can test the queries manually to see which syntax isn't accepted by the sensor. Does that help you to change the syntax accordingly?

Best regards, Felix


Sep, 2017 - Permalink

Our queries run fine in the SQLv2, but not in PRTG


Feb, 2022 - Permalink

Hi there,

If the query runs fine in the SQLv2.exe please let me know which error you receive in PRTG?


Feb, 2022 - Permalink