Votes:
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?
3 Replies
Votes:
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)).
Created on Dec 3, 2012 2:12:42 PM by
Votes:
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.
Created on Apr 1, 2014 10:48:05 AM by
Add comment