SCCM / MECM device collection QUERY to add cluster nodes that are currently active

Question

Hello guys,

I'm trying to create a device collection that includes servers that are SQL Cluster nodes but also that are Active Nodes. What would be the WQL query ?

Answer 1

Hi, @D D

Thank you for posting in Microsoft Q&A forum.

I'm afraid that SCCM do not collect the cluster info by default, you may need to add the relevant WMI classes to configuration.mof to collect relevant information.

However, we may try to find the Cluster nodes according to the service info like below, but not the node status.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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.DisplayName like "%Cluster%"  

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.