MSSQL V2 sensor evaluate returned value

Modified on 2025-06-10 16:52:04 +0200

Hi All,

I'm attempting to create a MSSQL sensor that will evaluate a returned value. The script will either return a 1 or a 0. I used to be able to do this with the old deprecated sensor type, however I can't see the option available in the new sensor type

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 there
We will need to take a closer look at the error code you are getting among other things. Can you run this script on the PRTG core server and confirm the script is valid? Would this link help in clarifying some questions?
https://helpdesk.paessler.com/en/support/solutions/articles/76000063105-how-can-i-monitor-strings-from-an-sql-database-and-show-a-sensor-status-depending-on-it

Feel free to open a ticket with us for further evaluation

Nov, 2022 - 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.

MSSQL V2 sensor evaluate returned value

Article CommentsAttention: 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.

Search

Attention

Related Articles

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.