PRTG sensor Microsoft SQL v2 Sensor can define one (1) imput parameter.
Customer monitor their business process environments by running batch jobs on multiple SQL instances. The PRTG sensor 'Microsoft SQL v2 Sensor' would render a massive amount of custom .sql files managed on multiple probe servers on '.\PRTG Network Monitor\Custom Sensors\sql\mssql'
This custom sensor is reusable with the system specific configurations defined in sensor parameters.
Add split function in SQL query to get multiple variables from @prtg
Write a 'EXE/Script Advanced Sensor' sensor with use of SQL Server Powershell commandlet.
The used SQLserver module only works with x64 and PRTG probe still uses x86 runtime on custom sensors the sensor restarts a new x64 powershell session and restart the sensor.
-ServerInstance SQLServer1 -GroupID 123 -DATAAREAID 789 -Age 60 -DatabaseName ERP1 -TableName Batch