Hi im having trouble to run this powershell command via custom sensor ...
running it with the powershellscriptrunner.exe i get only empty results - that seems to time out
$cmd = Invoke-Sqlcmd -ServerInstance instance -Database db -Query "SELECT * FROM tablexy where replicationsuccess = y/n $result = 1 try { if ($cmd.value -eq "N") { $result=0 $resulttxt="ok -$($cmd.value)-" } else { $resulttxt="Problem -$($cmd.value)-" $result=2 } } catch { $resulttxt="Problem catch" $result=1 return } Write-host "<prtg><result><channel>Replication</channel><value>$result</value><showChart>1</showChart><showTable>1</showTable><LimitMinError>0</LimitMinError><LimitMaxError>0</LimitMaxError></result><Text>$resulttxt</Text></prtg>"
result via powershellscriptrunner:
<prtg><result><channel>Replication</channel><value>2</value><showChart>1</showChart><showTable>1</showTable><LimitMinError>0</LimitMinError><LimitMaxError>0</LimitMaxError></result><Text>Problem --</Text></prtg>
result via powershell:
<prtg><result><channel>Replication</channel><value>2</value><showChart>1</showChart><showTable>1</showTable><LimitMinError>0</LimitMinError><LimitMaxError>0</LimitMaxError></result><Text>Problem --</Text></prtg>