Microsoft Configuration Manager
An integrated solution for for managing large groups of personal computers and servers.
4,332 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want to create a collection with all online clients(green checkmark), how to write the WQL query?
Hi, @CoolSK2
Thank you for posting in Microsoft Q&A forum.
We may use the wmi class called SMS_CollectionMemberClientBaselineStatus which has the client online status information.
select * from SMS_R_System where SMS_R_System.ResourceId in
(select resourceid from SMS_CollectionMemberClientBaselineStatus where SMS_CollectionMemberClientBaselineStatus.CNIsOnline = 1)
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 "Add 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.