Automation Policy for Populating Org Groups
I have an Automation policy set up that populates Organizations groups that I set up as well. It's doing what it is supposed to but I dont think it is getting all the computers I need. It is a raw SQL query for grouping specifically named computers:
Select GUID from vComputer where [IsManaged] = '1'
and [Name] like 'xxxx%'
and not [Name] like '%xxx%'
and not [OS Name] like '%xxxx%'
It will populate and give me a number of say 80. But if I go to Manage Computers and put in the same [name] I get a result that is different and probably more accurate. Is there a different query I should be using?