Hello everyone,

I've got an Oracle sensor that will elaborate a table like this:

Wardrobes | +10% Beds | + 25% Chairs | - 35%

Is it possibile to have a sensor that scan through the data and alert me when the percentage is over/under a certain limit?

For example, if limits will be +/- 25%, I want to receive an error from the sensor like: "Delta for category Beds outside limits" "Delta for category Chairs outside limits"

Article Comments

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.


Jul, 2020 - Permalink

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


Jul, 2020 - Permalink

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.


Jul, 2020 - Permalink

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!


Jul, 2020 - Permalink

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://helpdesk.paessler.com/en/support/solutions/articles/76000063572-how-can-i-propose-new-features-or-sensors-for-prtg


Jul, 2020 - Permalink

Hello again,

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


Jul, 2020 - Permalink

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.


Jul, 2020 - Permalink

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


Jul, 2020 - Permalink

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.


Jul, 2020 - Permalink