300

Hi t0ta11ed74 Did you find what was causing this error and we you able to fix it? I am getting the exact same error for Windows PowerShell Monitor. Only difference is that it's not random. The monitor is consistently failing with this error. I am poling frequency set to 300 seconds. Did you change polling frequency? And if…

in Powershell Monitor Random Unknown State Comment by 300 May 2018

Hi ttl, I am trying to find the same. Were you able to find a way to check whether and email alert was sent or not for a monitor?

in Email alert logging Comment by 300 July 2018

Finally it worked for me: Write-Host ("Statistic:{0}" -f $resultsDataTable.Column1) is what I needed and now is working. Thank you again :-)

in How to run a SQL on SQL Server DB with database name as parameter? Comment by 300 May 2018

I found how to turn on the debug log here: Turn on application debugging for SAM - SolarWinds Worldwide, LLC. Help and Support The monitor is still failing for me (showing NaN) and when I changed the statistic line to "Write-Host ("Statistic: " + $resultsDataTable.Rows.Count)" it shows 0. So I think there is something…

in How to run a SQL on SQL Server DB with database name as parameter? Comment by 300 May 2018

Thank you for your reply frak. I ended up using a SQL Server User Experience monitor using a customized SQL provided by DBA.

in How to monitor 'SQL Integration Services' (all versions) using a single 'Windows Service Monitor'? Comment by 300 October 2018

I think I found the problem. I had created 1 monitor and it was working fine for 10 pairs of output. So I went ahead and created a copy of it and modified it for the minor changes in SQL query and other changes. This second monitor was giving me error. When I deleted the second monitor and created it manually instead of…

in Max of 10 outputs in Script Monitor Comment by 300 May 2018

Hi, Did you find out a resolution for this error? I am also using "Windows powerShell Monitor" and getting this error for a monitor that shows 10 output pairs.To make it even weird for me, I have another monitor in the same template where everything else is same except a minor change in SQL that selects 10 rows from SQL…

in Max of 10 outputs in Script Monitor Comment by 300 May 2018

This is not exact solution for your question but just wanted to share it! We are monitoring Always On instances using custom SQLs provided by our DBA :-(

in Monitoring Always On SQL instances Comment by 300 May 2018

dmacphail Did you find a solution to this? If yes then can you please share as I am also trying to do the same with list of select nodes.

in How do I get a report that list all my nodes and all of the alerts assigned to them Comment by 300 August 2019

Hi. I am interested to know if this feature was made available. I have a case where I might be able to use this feature but I can confirm that only after having a look at it.

in How to do granular Database Monitoring on SQL Server 2005 with APM Comment by 300 April 2018

I had to update this line to include DRIVER={SQL Server}: $conn.ConnectionString = "DRIVER={SQL Server};Server=IP_ADDRESS;Initial Catalog=DB_NAME;Uid=$username;Pwd=$password;" It solved mt problem.

in How to create ODBC connection and run SQL from powershell? Comment by 300 May 2018

Finally, this worked for me: ${Application.Custom.<custom_property_name>} Just so that if someone comes to this thread for same issue.

in Can we use custom property values in Windows PowerShell Monitor? Comment by 300 May 2018

Comments