Can I separate Servers and Workstations in one SCCM?

Question

Can I separate Servers and Workstations in one SCCM?

sparkwit 1

Hello. Can I separate Servers and Workstations under the Devices in SCCM? We've one SCCM server. SCCM version: 2103. Thank you.

2 answers

Your answer

Answer 1

Garth 5,801

Yes, you can use RBA to control access to workstations or servers.

Jason Sandys 31,411 Reputation points Microsoft Employee Moderator

2021-06-04T19:35:15.857+00:00

The official documentation for RBA is at https://learn.microsoft.com/en-us/mem/configmgr/core/understand/fundamentals-of-role-based-administration

Answer 2

AllenLiu-MSFT 49,316 Microsoft External Staff

Hi, @sparkwit
Thank you for posting in Microsoft Q&A forum.
We can create two device collections using query rule:

For servers:

select * from SMS_R_SYSTEM where SMS_R_SYSTEM.OperatingSystemNameandVersion like "%Server%"

For workstations:

select * from SMS_R_SYSTEM where SMS_R_SYSTEM.OperatingSystemNameandVersion like "%workstation%"

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Jason Sandys 31,411 Reputation points Microsoft Employee Moderator

2021-06-07T13:47:41.637+00:00

Please don't use multiple wildcards in a single comparison within a WHERE clause. This is terrible performance-wise and is completely unnecessary as these conditions can definitely be made more specific using like 'Microsoft Windows NT Workstation%' and like 'Microsoft Windows NT Server%'.
AllenLiu-MSFT 49,316 Reputation points Microsoft External Staff

2021-06-08T02:15:12.997+00:00

Thanks Jason for the useful suggestion.

Share via

Can I separate Servers and Workstations in one SCCM?

2 answers

Your answer