I have the following within Spotlight on SQL Server:
Alarm: Monitored Server - SQL Server Collection Execution Failure
Key: SQL Cluster failover detection
Message: Collection ‘SQL Cluster failover detection’ failed : Execution state was not set
The remainder of the message are the steps to disable this monitor. Can anyone explain how to fix the root cause of this rather than just disabling the monitor within Spotlight?