Parameters | PRTG Database Observer Manual

PRTG Database Observer Manual

Parameters

Query execution supports the passing of variables. There are nine parameters in total available for each query.

Parameters are handled by simple, case-sensitive find-and-replace. If the query contains text @paramX (where X is number from 1 to 9) then all occurrences of @paramX will be replaced by according value.

Consider the following example query:

SELECT ‘@param1’ AS Channel, 258 AS Value,
 ‘’’@param1 - @param12 - @Param1,@Param1’’ will print test – test2 - @1param1,@PAram1’ AS
Channel_Settings

Execute the query with these parameters:

-profile:TESTPROFILE -query:testParamExample"-params:@param1:test“

Example result of parameter replacement

Example result of parameter replacement