New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


SQLSensor query returning text/string - DISPLAY MAP

Votes:

0

Your Vote:

Up

Down

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?

map message prtg sqlsensor

Created on Nov 30, 2012 1:59:49 PM by  MarcProvant (0) 1



3 Replies

Votes:

0

Your Vote:

Up

Down

Hello,

you can do this by following: http://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  Torsten Lindner [Paessler Support]



Votes:

0

Your Vote:

Up

Down

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.

Created on Mar 31, 2014 5:41:41 PM by  nrgcc (0) 1



Votes:

0

Your Vote:

Up

Down

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  Torsten Lindner [Paessler Support]



Please log in or register to enter your reply.


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.