Does Fleet have the ability to group results from multiple hosts? I"m looking for something like

SELECT version, COUNT(version) FROM os_version GROUP BY version;

that will tell me something like this for the whole fleet.

+---------+----------------+
| version | COUNT(version) |
+---------+----------------+
| 12.2.1  | 18             |
| 12.3.1  | 186            |
+---------+----------------+

hi! not currently

Not in Fleet directly, but I ❤️ unix tools, so I'd recommend this:

fleetctl query --labels 'All Hosts' --query 'SELECT version FROM os_version' --timeout 15s | jq '.rows[0].version' | sort | uniq -c
 56% responded (91% online) | 10/18 targeted hosts (10/11 online)
Stopped by timeout
   1 "11.6.3"
   2 "12.2.1"
   1 "12.3"
   4 "12.3.1"
   2 "20.04.3 LTS (Focal Fossa)"
   1 "CentOS Stream release 8"

Beat me to it 🙂

fleetctl get hosts --json | jq '.spec .os_version' | sort | uniq -c

Ah love it Kathy! Even simpler!

Thanks!