Could you please provide help for command line parameters for your SQLv2.exe executable? The idea is to build a custom notification that will update my SQL database in a result of error situation for specific sensors.

Article Comments

Hi Tomasz,

The easiest way to get the parameters is to add the sensor once normally within PRTG. Afterwards enable the "Write Result to Disk" option in the sensor and check the logs under "C:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)\" - especially the "Result of Sensor XXXX.Data.txt"-file. The line "Data['exeparams'].asString" will show all used parameters, similar to:

"-dbuser=test" "-dbpass=***" "-host=host" "-dbauth=1" "-database=mysql" "-timeout=60" "-server=mysql" "-handledbnull=1" "-querytype=ChangeDB" "-transaction=noTransaction" "-selectvalue=ColumnID" "-channelids=" "-selectors=" "-includeruntime=1" "-isdif=" "-sqlpath=C:\Program Files (x86)\PRTG Network Monitor\custom sensors\sql\mysql\Demo Serveruptime.sql" "-writefile=C:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)\Result of Sensor 6105.log"

Best regards.


Jun, 2018 - Permalink

This is exactly what I did as a first approach. Some parameters are obvious but others not and this is why I asked for support. Eg. of my doubts: dbauth, handledbnull, querytype, transaction, isdif.


Jun, 2018 - Permalink

Hi there,

Unfortunately, there is no official documentation. The best way would be to test the query from within PRTG and then copy the parameters from the result file.

Best regards.


Jun, 2018 - Permalink