Hello. Can I separate Servers and Workstations under the Devices in SCCM? We've one SCCM server. SCCM version: 2103. Thank you.
Hello. Can I separate Servers and Workstations under the Devices in SCCM? We've one SCCM server. SCCM version: 2103. Thank you.
Yes, you can use RBA to control access to workstations or servers.
The official documentation for RBA is at https://docs.microsoft.com/en-us/mem/configmgr/core/understand/fundamentals-of-role-based-administration
Hi, @sparkwit-2206
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.
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%'.
9 people are following this question.