Hi. The reason for this is to consult a question about the SQL Server Sensor.

Currently, I am running a Select query that can return multiple rows (Only one column). The conditions for this sensor to be executed are the following: - Good = 0 Rows. - Fail = 1 or more rows.

How can I configure my sensor so that when there are 1 or more rows in the result of my query, send the values of the rows in the message of the notification?

Greetings and blessings. Atte.

Article Comments

Hi there,

There is not a default solution here, but you could use the following workaround to show the columns as message with the following steps:

  1. Switch to the settings of the sensor
  2. Below "Data Processing > Process data table" enable "Sensor Message Column Number"
  3. Choose the "Sensor Message Column Number"
  4. If a message is sent, it will also display the the information that is displayed as Sensor message.
    Please let me know if this fits your requirements.

Kind regards,
Birk Guttmann, Tech Support Team


May, 2019 - Permalink

Hi, Birk Guttmann.
Thanks for your help.
I tried to configure my sensor with the information that you provide me but I do not achieve satisfactory results. In the message, only the first Row appears. For example, if my Query Select returns 11 rows, the message shows row 1 and the other 10 are lost.

Have you had the opportunity to see or solve a similar case? Maybe and I'm not properly configuring the sensor.


May, 2019 - Permalink

Hi there,

That's correct, it only shows the first row. Unfortunately there is not default possibility to return more rows here.

Kind regards,
Birk Guttmann, Tech Support Team


May, 2019 - Permalink

Hi Okay, thank you very much, Birk Guttman. In this case, the solution that I will choose, will be to return all the rows in a single row.Do you know if this message has some string length limitation?

Greetings and blessings. atte.


May, 2019 - Permalink

Hi there,

I'm not sure, but I think the string length limitation should be very big here. I don't think you have to worry about this.

Kind regards,
Birk Guttmann, Tech Support Team


May, 2019 - Permalink