Create Query-Based SCCM Device Collections
In this article, I’ll walk you through step-by-step creation of query-based device collections , along with ready-to-use queries for: Windows Server 2016 / 2019 / 2022 / 2025 All Servers Windows 11 (latest builds) Windows 10 versions Step-by-Step: Create Query-Based Device Collection Follow these steps in Microsoft Endpoint Configuration Manager console: 1. Open SCCM Console Go to Assets and Compliance Click on Device Collections 2. Create New Collection Right-click Device Collections Select Create Device Collection 3. General Settings Name : Enter collection name (e.g., Windows Server 2025 ) Limiting Collection : use All Systems 4. Add Membership Rule Click Add Rule → Query Rule Provide: Name : e.g., Server 2025 Query Click Edit Query Statement 5. Add Query Go to Show Query Language Paste your query (from below sections) 6. Complete Wizard Click OK → Next → Close 7. Update Collection Right-click collect...