create collections by computer name

Question

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.

Answer 1

@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.

Answer 2

Thank you for responding, excellent.