SCCM Device Collection – Windows Server 2016 and Server 2019

This post will help you if you want to create SCCM device collection for Windows Server 2016 and Windows Server 2019. SCCM 1810 now supports Windows Server 2019 as site systems. That’s a great addition and SCCM 1810 comes with lot of new features. You can check my SCCM 1810 upgrade guide to view the upgrade steps. Customers are now looking to adopt Windows Server 2019 because it’s latest and improved over 2016. I personally don’t like Windows Server 2016. I faced lot of issues in updating the server, so I am hoping that Server 2019 will be good.

In my lab setup I already had my SCCM 1810 installed and running. I was testing the SCCM client agent installation on Windows Server 2019 and it got installed successfully.

SCCM Device Collection – Windows Server 2016 Windows Server 2019

If you are looking to create SCCM device collection for Windows Server 2016 and Windows Server 2019, I will provide you the query for it.

First of all, let us find the OS version so that it becomes easy to create device collection. Note that you can try others methods to create device collection apart from the one mentioned in this post.

Login to Windows Server 2016, launch command prompt. Type systeminfo and press enter. Look for OS Version. If it’s a Windows Server 2016, the OS version is 10.0.14393.

SCCM Device Collection Windows Server 2016 and Server 2019

Similarly execute the same command on Windows Server 2019. For Windows Server 2019, the OS version is 10.0.17763.

SCCM Device Collection Windows Server 2016 and Server 2019

Now that you know the OS version of Windows Server 2016 and Windows Server 2019, let’s create a device collection.

SCCM Device Collection for Windows Sever 2016

  • In the SCCM console, right click Device Collections.
  • Click Create Device Collection.
  • Specify the name of collection and set a Limiting Collection.
  • In the next screen, click drop down Add Rule. Click Query Rule.
  • Specify Query name and click Edit Query Statement.
  • Click Criteria under Query Statement Properties and then click Show Query Language.
  • Paste the below query and click OK.

SCCM Device Collection Windows Server 2016 and Server 2019

SCCM Device Collection for Windows Sever 2019

  • In the SCCM console, right click Device Collections.
  • Click Create Device Collection.
  • Specify the name of collection and set a Limiting Collection.
  • In the next screen, click drop down Add Rule. Click Query Rule.
  • Specify Query name and click Edit Query Statement.
  • Click Criteria under Query Statement Properties and then click Show Query Language.
  • Paste the below query and click OK.

 

SCCM Device Collection Windows Server 2016 and Server 2019

You might also like

3
Leave a Reply

2 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
Doug

Based on the revised query, I would recommend doing Caption like “Microsoft Windows Server%” so you don’t exclude any Standard edition servers in the environment.

Doug

The OS version for Server 2016 is the same as the OS version for Windows 10 1607. The query provided will create a collection with Server 2016 and Windows 10 1607. You will also need to add a criteria such as specifying “Caption like Server” or “Caption not like Windows 10” to exclude the client OS. The same is true for Server 2019 and Windows 10 1809.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More