Can you provide more details so other community members can help?
sorry, i have a mistake. what I really need is a filter for windows 8 computers that are not managed
SELECT Guid from vComputer WHERE [OS Name] like 'Windows 8%' and [isManaged] = '0'
The SQL for this is actually quite easy.
An example would be:
SELECT Guid FROM vComputer
WHERE [OS Name] LIKE 'Windows 8%'
AND IsManaged = 0