Sensor with multiple channel from a single query

Hi there,

You can try to use the option "Process data table" in the settings of "Oracle SQL v2 Sensor".
This setting triggers the Sensor to read and analyze the queried data table. If you select this option, the sensor counts rows with SELECT statements as well.

I tried but the sensor shows me only the first record, it seems it doesn't process the full table ...

In this case, I recommend to create a SQL query which already checks for the delta and lists only the rows which fulfills the requirements. Afterwards, you can use the Sensor to count these rows.

I used this method but the sensor only tells me how many problems there are, but not on which element that I've to manually search, instead I want that the sensor will tell me what element is in error, is not possibile?

I also tried to split the sensor and create 1 sensor for each element, and everything works, but each time I add an element to the table, I've to remember to create the relative sensor and this is not so good!

Hi there,

I'm sorry but as you already found out, the only way for this detailed information is to create a Sensor for each object.
If you know which certain feature would help you, you can create a feature request for PRTG so PRTG is able to do better SQL queries in the future. Therefore, please follow these steps: https://kb.paessler.com/en/topic/79245-how-can-i-propose-new-features-or-sensors-for-prtg

Hello again,

I need to ask a thing: how's the "Process data" option will work? I don't understand how this option work.

With this option you can map results of your query in single channels. For example, you have in column "data size" the value you want to have in the channel, then you configure "Column name" and then the name of the column. Afterwards, this channel will display the value from this column.

It reads only the first record, right? Is there something to read multiple record?

Hi Andrea,

this depends on what you configure. If you select "Number of Row" in the data processing feature, PRTG will import the value from one row in each channel. Please note that this is only useful, if you have only one column.