create collections by computer name

Rafael Aguilar 496 Reputation points
2020-10-13T21:58:22.963+00:00

Hi,Team.

I need to create several collections because of the computer nomenclature.

In this example many computers start with "ari" and another one with the word "ari" in the middle. For example aguari003.

I know that I can group all the teams that start but I don't know how to group the teams that have the combination in the middle.

If someone could guide me I would hate some idea.

Thanks.

32201-image.png

Microsoft Configuration Manager
0 comments
Accepted answer
  1. AllenLiu-MSFT 43,051 Reputation points Microsoft Vendor
    2020-10-14T01:37:09.223+00:00

    @Rafael Aguilar
    Thank you for posting in Microsoft Q&A forum.
    If we need have the word "ari" in the middle but not start with "ari", we may use the query: 

    Select * from SMS_R_System where Name like "%ARI%" and Name not like "ARI%"

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rafael Aguilar 496 Reputation points
    2020-10-14T11:59:50.973+00:00

    Thank you for responding, excellent.

    0 comments