Creating Filter Based on Computer Name
I'd like to create a filter based on computer name. I'm sure I'm missing something simple.
I started by following this video, which works except it also returns image and user resources with %compname% in them.
I tried this and it's also returning image and user resources with %compname% in them.
FROM vComputer vC
WHERE vC.[Name] LIKE '%compname%'
ORDER BY vC.Name ASC
What's the best way to limit the filter to just show computer resources?