ok I guess the answer is that the tables aren’t directly exposed via API and I can’t query them directly. In that case, how can I pull a list of all my hosts and their labels please?

Hey Adam! Correct, those are Fleet database tables. You can filter hosts by label in the UI or use the `labels`API endpoint. https://fleetdm.com/docs/using-fleet/rest-api#labels

thanks @Kathy Satterlee, I’ve looked over the docs again, and I still can’t see the solution. My goal is to get a list of all hosts and their labels using the API. From the docs it looks like my only solutions are • get a list of all the labels via API and do multiple queries iterating through those labels, then deleting double ups that overlap due to having multiple labels • modifying the default ‘hosts’ query to make it add the labels to the response Am I missing anything here? Is there an easier solution?