I've created a sqlsensor which executes a query. The query returns a message, which is disabled in "Sensor status" in the Message-column. When placing this sensor on a map, it is apparently not possible to have the message displayed, only the status and/or value (which in this case is 0).

Is it possible to have the result of the query (one record, one column which is a string) in the Value-channel?

Article Comments

Hello,

you can do this by following: https://www.paessler.com/knowledgebase/en/topic/1703-how-can-i-add-or-edit-map-objects-used-for-prtg-s-maps

and then replace the

<#objectstatus name="lastvalue" id="<@objectid>">

with

<#objectstatus name="message" id="<@objectid>">

For example in the "An Icon B2.htm" (Status Icons: Status and Last Value (On White)).


Dec, 2012 - Permalink

I wonder why this doesn't work with an Oracle sensor. The last "message" just comes up as "OK" instead of the actual string results of the query I ran.


Mar, 2014 - Permalink

The above code should still work, and did work on a quick test here. Please try it with a different sensor. What happens most likely, is that "Ok" is the actual sensor message (which is displayed like this), and not the result of the SQL-Query.


Apr, 2014 - Permalink