Client Management Suite

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.

https://www-secure.symantec.com/connect/videos/symantec-management-platform-how-create-dynamic-filter

I tried this and it's also returning image and user resources with %compname% in them.

SELECT *

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?

If you try that SQL in SQL Query Analyser and it still user records you might need to look at the SQl used to generate the views, mine don't have any User resources in.

Do the user resources have a MAC Address? If not only grab results that do.

SELECT *

FROM vComputer vC

WHERE vC.[Name] LIKE '%compname%'

ORDER BY vC.Name ASC

Something to try anyway

Try using the base computer resource view:

SELECT *

FROM vRM_Computer_Item vC

WHERE vC.[Name] LIKE '%compname%'

ORDER BY vC.Name ASC

@Andrew Bosch

Thanks, that worked.