Regarding the issue of SCCM creating device sets

Question

1.pdf

Create SCCM device query computer name based on image information. The first and second digits are FZ XM GZ SZ WH CD FS, the third digit is L D M, the fourth and fifth digits are ZB 01-09 ZC QB YC DH, the sixth, seventh, and eighth digits are YYB GGZ CCW CXB FWH SCB RZX CWB TGB JSY KFJ 001-009. If the sixth, seventh, eighth, and ninth digits are KFZX, then the tenth digit starts with numbers. If the sixth, seventh, and eighth digits are not KFZX, then the ninth digit starts with numbers, which will not meet the above requirements. Filter out the computer names of the conditions and place them in the device collection

Answer 1

Based on the provided context, it is not clear what SCCM device query is being referred to. The context provides information on how to import and create device collections in SCCM, but not on how to create a device query based on the criteria provided in the question. Therefore, I am unable to answer the user's question.

---

References:

• Quick Start Guide for Microsoft System Center 2012 R2 Configuration Manager
• Quick Start Guide for User-Driven Installation
• Device images

Answer 2

Look at using the "Like" statement within your query to do this.

Answer 3

Hi, @dfs

Thank you for posting in Microsoft Q&A forum.

You may follow this to create a device collection with a query rule:

https://learn.microsoft.com/en-us/mem/configmgr/core/clients/manage/collections/create-collections#bkmk-query

Like Garth suggested, you may use the "like" statement to filter out the computer manes.

For example:

Select * from SMS_R_System where SMS_R_System.Name like '%FZ%'

---

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".