Hello,
Are you looking for what filters a computer is a member of?
I adapted this from another post out there somewhere. Sorry I could not find the original poster to provide you with the link.
If this is what you're looking for, you can use this...
SELECT vcollection.[Name] AS [Collection/Filter],vcollection.[Description]
FROM vCollection
JOIN CollectionMembership ON CollectionMembership.[CollectionGuid] = vcollection.[Guid]
JOIN vComputer ON vcomputer.[Guid] = CollectionMembership.[ResourceGuid]
WHERE vcomputer.[Name] = 'pcname here'