Solutions
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Infrastructure as code
See every change, undo any error, repeat every success.
Extend Fleet
Integrate your favorite tools with Fleet.
More
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Infrastructure as code
See every change, undo any error, repeat every success.
Extend Fleet
Integrate your favorite tools with Fleet.
Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
Apple
Linux
Windows
ChromeOS
mounts
System mounted devices and filesystems (not process specific).
| Column | Type | Description |
|---|---|---|
| blocks | bigint | Mounted device used blocks |
| blocks_available | bigint | Mounted device blocks available to non-root users |
| blocks_free | bigint | Mounted device blocks available to root users, a superset of blocks_available |
| blocks_size | bigint | Block size in bytes |
| device | text | Mounted device |
| device_alias | text | Mounted device alias |
| flags | text | Mounted device flags |
| inodes | bigint | Mounted device used inodes |
| inodes_free | bigint | Mounted device free inodes |
| path | text | Mounted device path |
| type | text | Mounted device type |
Returns the drive free space in gigabytes and as percentage.
SELECT path, type, ROUND((blocks_available * blocks_size * 10e-10), 2) AS free_gb, ROUND ((blocks_available * 1.0 / blocks * 1.0) * 100, 2) AS free_pc FROM mounts WHERE path = '/';