question

sparkwit-2206 avatar image
0 Votes"
sparkwit-2206 asked AllenLiu-MSFT commented

Can I separate Servers and Workstations in one SCCM?

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

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT commented

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

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.



111.jpg (88.4 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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%'.

0 Votes 0 ·

Thanks Jason for the useful suggestion.

0 Votes 0 ·
Garth avatar image
1 Vote"
Garth answered Jason-MSFT commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.