We have a custom application monitor for SQL services that has stopped working since we upgraded to version 2020.2.1. It gets the message "Sequence contains no elements". I opened a support case with Solarwinds, but have not made any progress.
We successfully tested the following query using the WMI testing tool:
Select * From Win32_Service WHERE Name like '%MSSQL%' and State='Running' or Name like '%SQLAGENT%' and State='Running'
Does anyone have any ideas what might be causing this issue? Please let me know if I need to provide more information.
Thanks,
David