Hello.. what is the query to calculate total disk space on a linux machine. The queries i am using are not matching with the data brought in by other tools. The query i used are: 1. SELECT ROUND(SUM(blocks * blocks_size) / (1024 * 1024 * 1024), 2) AS a_total_disk_space_gb, ROUND(SUM((blocks - blocks_free - blocks_available) * blocks_size) / (1024 * 1024 * 1024), 2) AS b_total_all_gb FROM mounts; 2. SELECT ROUND(CAST(SUM(blocks_size) AS DECIMAL) / (1024 * 1024), 2) AS disk_space_gb FROM mounts; Note: The query for Windows disk space is working fine: (SELECT round(SUM(disk_size)/1073741824.0,0) AS total_disk_space_in_gb FROM disk_info) as total_disk_space_in_gb,

Does this help? https://fleetdm.com/docs/using-fleet/detail-queries-summary#disk-space-unix

Thanks for the input John. I tried the query and the result shows 'available disk space'. Do you know what i need to do to get 'total disk size' Thanks in advance 🤝

No, sorry.

maybe https://osquery.io/schema/5.8.2#disk_info