SCCM Collection for each WIndow version

Trinh Chi Trung 20 Reputation points
2025-11-27T10:23:54.0066667+00:00

Query to create SCCM Collection for each Window version

Microsoft System Center | Other
{count} votes

2 answers

Sort by: Most helpful
  1. Q&A Assist
    2025-11-27T10:24:34.25+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To create a SCCM (System Center Configuration Manager) collection for each Windows version, you can use query rules based on the Windows version. Here’s a general approach to create such collections:

    1. Navigate to Assets and Compliance in the SCCM console.
    2. Select Device Collections and then click on Create Device Collection.
    3. Provide a name for the collection and choose a limiting collection.
    4. Click on Add Rule and select Query Rule.
    5. In the Query Rule Properties dialog, specify a unique name for the query.
    6. Use the Edit Query Statement option to create a WQL (WMI Query Language) query that filters devices based on the Windows version. For example:
         SELECT * FROM  SMS_R_System WHERE SMS_R_System.OperatingSystemNameandVersion LIKE '%Windows 10%'
      
      Adjust the query to match the specific version of Windows you want to target.
    7. After configuring the query, click OK and complete the wizard.

    Repeat these steps for each Windows version you want to create a collection for, modifying the query accordingly.

    This method allows you to dynamically manage collections based on the Windows versions running on your devices.

    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.