I have an custom sql sensor with a query. Its about 121 lines. Every line should be a channel in the sensor. I use the key value pair.
It would be also possible to use every value in the row 0 for one channel, if this is working somehow.
I want to import channels to an custom SQL sensor
Modified on 2025-06-10 16:43:07 +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.
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.
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.
I see that you would like to have 121 channels in a custom sql sensor using Selection by Key Value Pair, is this correct?
Using Channel Value Selection by Key Value Pair will return the value of the column predefined from the row associated to the key value.
And for your question in regard to if it is possible to use every value in row 0 for one channel.
How many columns do you have in row 0? If row 0 contains many columns in the same row it won't be possible to have an exclusive channel since the combination of values in one channel to reflect all attributes in one row will not be possible. If you need this, you must reconstruct your data table.
For more information on how the structure of the please refer to the document Sensors Monitoring Databases Directly.
If you need further assistance please open a ticket with support@paessler.com and we can continue assisting you from there.
Mar, 2023 - Permalink