Spotlight has the following Cluster alarms:
1. Clusters – Failed Over (message – The cluster has failed over from <PreviousHost> to <Host>)
2. Clusters – Node Unavailable (message – At least one cluster node is unavailable)
3. Clusters – Non-Preferred Node (message - <ClusterName> is not running on its preferred cluster node)
Along with an additional connection alarm:
4. Monitored Server - <Windows/SQL Server> Connection Failure alarms.
The first two cluster alarms in conjunction with the Monitored Server alarm will cover the first two SCOM alerts.
For the third SCOM alert, enhancement request SOSSE-4168 has been submitted to Development for consideration in a future release Spotlight on SQL Server Enterprise.