What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

MSSQL V2 sensor evaluate returned value

Votes:

0

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

microsoftsql mssql sqlsensor

Created on Nov 21, 2022 9:03:10 PM



1 Reply

Votes:

0

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://kb.paessler.com/en/topic/63259-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

Created on Nov 29, 2022 2:58:42 AM by Luis Quesada (Paessler Technical Support)




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.