Is there a way to include the Device Group in a query? I haven't found one. I know I can filter a query to apply only to certain groups but that doesn't help.
Here's my scenario: I have device groups for each of our locations, and we try to keep them organized as best we can. But as devices are removed and added all the time, the groups get outdated and inaccurate quickly. If I could run a query for all machines that match a location's naming convention and there was a column in the query that said which device group they were in, then it'd be easy to move the ones that haven't been filed to the correct/any group.
Is there a way to achieve this?