João Godinho
01/08/2020, 12:29 PMSELECT 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?