Powershell custom sensor issue

Hello,

Thank you for your message.

Can you please provide us the following information:

• PowerShell version
• .NET Framework installed
• Windows version

Please, share the content of the script as well (without any confidential information).

Regards.

Hello,

$sqlsmd = " a sql select query that returns 6 fields of data"


try {
    

    $result = Invoke-Sqlcmd -Query $sqlsmd -ServerInstance $target -Database $DataBase
}
catch {
    Write-Output "echo    <?xml version=""1.0"" encoding=""Windows-1252"" ?>"
    Write-Output "echo    <prtg>"
    Write-Output "echo    <error>1</error>"
    Write-Output "echo    <text>Query Failed: $($_.Exception.Message)</text>"
    Write-Output "echo    </prtg>"
    Exit
}

Hello,

Thank you for the information.

Can you please execute the PowerShell script by using PowerShellScriptRunner.exe located under "C:\Program Files (x86)\PRTG Network Monitor", with the command:

.\PowerShellScriptRunner.exe -script="full script path"

What result do you get ?

Regards.

Hi Florian,

what's the purpose of using this as opposed to the current work around I have in place which is:

powershell.exe -file "C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\EXEXML\xxx-Stats.ps1"

I guess I was hoping for a fix or a way of running the sensor as as described in the knowledgebase.

regards

Hello,

Can you continue to use your workaround without any issue. The instruction I provided above should help to check where this error comes from exactly when directly executing the script via PRTG (without the workaround).

Have you tried to execute the script by using the option Use Windows credentials of parent device next to Security Context in the sensor settings? If not, I invite you to test that option which will execute the script as the user defined in the parent device settings (under Credentials for Windows Systems) instead of Local System.

Regards.