We have about 15,000 hosts inventoried in the OCS. We need to perform a cleanup of hosts that have not reported their inventory for more than x days. This number exceeds 2,000. We have seen the option to delete old hosts, but there are certain old hosts that we don't want to delete because they actually do exist, but they present a problem when reporting their inventory to the server and we want to keep them.
We have taken a look at the internal structure of the DB and we have not located cascading deletion or definition of foreign keys.
In order not to have to click one by one in the console, could you tell me if there is any way to delete hosts by entering a list of names? Any automation would be valid, either from the web console, API, SQL query or any other.
- Server version: 3.10.0-1062.4.3.
- Agent version: 22.214.171.124
Any help would be very welcome. Thanks a lot.