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.
Extend Fleet
Integrate your favorite tools with Fleet.
Customers
Fintech + Fleet
Fintech giant consolidates multiple tools with Fleet.
Foursquare + Fleet
Foursquare quickly migrates to Fleet for device management.
What people are saying
Stories from the Fleet community.
More
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 = '/';