MSSQL V2 sensor evaluate returned value
Modified on 2025-06-10 16:52:04 +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.
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
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.
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