PRTG 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
