Introduction

System Center Configuration Manager (SCCM) is a powerful tool used by Microsoft Systems Engineers to manage and deploy software, updates, and configurations across a network of Windows computers. One of the key features of SCCM is the ability to create collections, which are logical groups of computers that share certain characteristics or meet specific criteria. These collections can then be used to target software deployments, apply configurations, or run reports.

In this article, we will focus on creating a collection query in SCCM that identifies computers manufactured by Lenovo. This can be useful in scenarios where you need to target specific software or configurations to Lenovo computers or perform hardware inventory analysis for Lenovo devices.

Examples:

To create a collection query for SCCM that identifies Lenovo computers, follow these steps:

1. Open the SCCM console and navigate to the "Assets and Compliance" workspace.
2. Expand the "Device Collections" node and right-click on "All Systems" or any other existing collection where you want to add the query. Select "Create Device Collection" to create a new collection or "Properties" to modify an existing collection.
3. In the "General" tab of the collection properties, provide a name and optional description for the collection.
4. Switch to the "Membership Rules" tab and click on the "Add Rule" button.
5. Select "Query Rule" from the drop-down menu and click on the "Edit Query Statement" button.
6. In the "Query Statement Properties" window, switch to the "Criteria" tab and click on the "New" button.
7. In the "Criterion Type" drop-down menu, select "Simple Value" and click on the "Select" button next to "Attribute Class".
8. In the "Select Attribute Class" window, choose "System Resource" and click on the "OK" button.
9. In the "Attribute" drop-down menu, select "Manufacturer" and set the operator to "Like".
10. In the "Value" field, enter "Lenovo%" (without quotes). This query will match any manufacturer name that starts with "Lenovo".
11. Click on the "OK" button to close the "Query Statement Properties" window.
12. Back in the "Query Rule Properties" window, click on the "OK" button to save the query rule.
13. Click on the "OK" button again to save the collection properties.

Now, the collection will dynamically update and include all computers that have "Lenovo" as the manufacturer in their hardware inventory. You can use this collection to target software deployments, apply specific configurations, or run reports specific to Lenovo computers.