Convert message string to numbered value or how to monitor string messages of a sensor in a PRTG map

Hi Robert,
If the target device provides a value like 1 = active, 2 = passive for the status. Then you need to create a lookup file which helps PRTG to interpret the provided values.
You can find more information here.

Hi Marijan,

thanks for response. The response value is not numerical, it is a string value.

I tried the custom value lookup and at first it looks good. But only for live View. For the more interesting long time map monitoring it does not work, because the numerical value is not used, instead the unit changes from # to %. I found a matching topic: https://kb.paessler.com/en/topic/73062-can-i-graph-text-values

My custom Lookup is:

<?xml version="1.0" encoding="UTF-8"?>
  <ValueLookup id="ewr.activepassive.hastatus" desiredValue="0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PaeValueLookup.xsd">
    <Lookups>
      <SingleInt state="OK" value="1">
        Active
      </SingleInt>
      <SingleInt state="OK" value="2">
        Passive
      </SingleInt>
    </Lookups>
  </ValueLookup>

Any further idea how to solve the Problem? Active should be interpreted an displayed as 1 and Passive as 2.

Hi Robert,

You need to change the values for the different states to active and passive, as your target device provides a string instead of numeric values. Kind regards Marijan

Hi Marijan,

What do you mean? I already have changed the original activeinactive lookup and values to Active and Passive. And in the live Graph the Active state is recognized as 1 and the Passive state as 2. But it does not work for other graphs.

Kind regards

Robert

Hi Robert,

The lookup should look like this when the target device doesn't provide a numeric value.

<?xml version="1.0" encoding="UTF-8"?>
  <ValueLookup id="ewr.activepassive.hastatus" desiredValue="0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PaeValueLookup.xsd">
    <Lookups>
      <SingleInt state="OK" value="Active">
        Active
      </SingleInt>
      <SingleInt state="Error" value="Passive">
        Passive
      </SingleInt>
    </Lookups>
  </ValueLookup>

As you mentioned that the device is reporting a string.

Hi Marijan,

But that is not what I want, the string should be converted to a numerical value that PRTG is able to monitor over time. To Monitor the actual State of the Cluster I do not need a custom value lookup. Even I think that the values Active and Passive are not Type Integer (SingleInt), so it is not being accepted from PRTG.

So if there is no way to use the regex function (for example to determine string-length), or other easy PRTG integrated way to convert string to numerical value, than I have to ask if anyone in my company is capaple to script. I guess with the exe/script sensor it should be possible, but I by myself does not have any clue about scripting and as mentioned earlier regex and Pearl / PCRE.

Thanks so far

Kind Regards

Robert

Hi Robert,

Then I would ask you contact one of your colleagues if they can create a script for. You can monitor this script with PRTG with the EXE/Script Advanced Sensor.

Hi Marijan,

I tried for myself the Script-Solution (simple exesensor) and I guess I found my solution.

My script.bat (IP, community and OID are command-line parameters from PRTG sensor): I'm sure there is a much better (coding) way to do it^^ But it works for me with Infoblox and Checkpoint HA Status.

@echo off

"C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXE\SnmpGet.exe" -r:%1 -v:2c -c:%2 -o:%3 |find "Value" >C:\PRTG-scripts-results\%1.txt

Set /p VAR2= < C:\PRTG-scripts-results\%1.txt
Set VAR=%VAR2:~6%

if "%VAR%"=="Active" (
 SET RESULT=1
 ) else (
 if "%VAR%"=="active" (
  SET RESULT=1
  ) else (
  if "%VAR%"=="Passive" (
   SET RESULT=2
   ) else (
   if "%VAR%"=="standby" (
    SET RESULT=2
    ) else (
    if "%VAR%"=="Active Attention" (
     SET RESULT=3
     ) else (
     if "%VAR%"=="down" (
      SET RESULT=4
      ) else (
      SET RESULT=5
      )
     )
    )
   )
  )
 )

SET /A RESULT=%RESULT%

echo %RESULT%:%VAR%

Hi Robert, Great to hear that it is working now.