Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Creating Filter Based on Computer Name

Created: 12 Dec 2012 • Updated: 14 Dec 2012 | 4 comments
This issue has been solved. See solution.

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/sym...

 

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?

Comments 4 CommentsJump to latest comment

andykn101's picture

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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

aschuler's picture

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

 

 

SELECT *

FROM vComputer vC

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

 

AND vC.[Mac Address] IS NOT NULL
AND vC.[MAC Address] != ''

ORDER BY vC.Name ASC

 

Something to try anyway

Andrew Bosch's picture

Try using the base computer resource view:

 

SELECT *

FROM vRM_Computer_Item vC

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

ORDER BY vC.Name ASC

------------------------------------
Sr. Principal SQA Engineer
Symantec

SOLUTION
Sally5432's picture

@Andrew Bosch

Thanks, that worked.  

---
Don't forget to mark posts as helpful if they are, and mark answers as solutions.