Windows Failover Clustering is a critical feature used to provide high availability and workload continuity for enterprise applications and services. In this article, we will create an SCCM device collection query to identify servers with the Failover Clustering feature enabled. This collection can help administrators simplify monitoring, patch management, compliance reporting, and operational management for clustered server environments.
select * from SMS_R_System inner join SMS_G_System_SERVICE on
SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where
SMS_G_System_SERVICE.Name = "ClusSvc"
