osQuery Management Server (Prime).Available Disk Space (Linux and Macos) (SQLite SQL Statements)

    SELECT 
      (blocks_available * 100 / blocks) AS percent_disk_space_available,
      round((blocks_available * blocks_size * 10e-10),2) AS gigs_disk_space_available,
      round((blocks           * blocks_size * 10e-10),2) AS gigs_total_disk_space
    FROM mounts
    WHERE path = '/' LIMIT 1;