schorschii / OCO-Server

Open Source Computer Orchestration Server - Client/Endpoint & Server Inventory, Configuration Management, Automation and Software Rollout/Deployment/Distribution
https://oco.sieber.systems
GNU General Public License v3.0
50 stars 13 forks source link

Dynamic computer groups based on reports #18

Closed VRDD closed 2 years ago

VRDD commented 2 years ago

First of all thanks for this fantastic piece of software which works like a charme! :-)

Would it be possible to add dynamic computer groups that can be populated by reports?

Cheers, VRDD

VRDD commented 2 years ago

The requested feature has been already implemented: You can create a report using statements like this:

SELECT id AS 'computer_id', hostname, os, os_version, model From computer WHERE hostname LIKE 'L%' and os LIKE 'Windows%';

As described in the documentation it is necessary to rename the id column to "computer_id". If done so, the report result can be used like a computer group for instance for distributing software.