Collection Query statement that findes computer models

[denmyos]

hi

 

I want to make 1 collections with 1 query statement in.

 

collection:

A collection with all computers with the name that starts with NKLT......

 

I kinda lost on this one. I'm new to query's.

 

Sorry: the titles should have said "Names" Not Models.

 

Thanks

 

PS. this has just been upgraded to a query that finds all the computers named NKLT, BUT now it also need sort the result into models.?

Like how many computers named NKLT is Dell and how many is Lenovo.. if i could get the computer number aswell, that would be great.

 

Any help would be greatly appriciated

Edited March 10, 2020 by denmyos