Hi :wave: I have this query: ```SELECT directory, ...
# general
j
Hi 👋 I have this query:
Copy code
SELECT directory, ROUND((SUM(size) * 1e-6),2) AS size_mb from file
WHERE path LIKE "/var/osquery/osquery.db/%"
GROUP BY directory ORDER BY size_mb DESC;
that I’m running in all hosts via fleet. The
ORDER BY
is pointless, given that each machine is running the query individually, but is there a way to sort this in fleet?