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.
Customers
Pricing
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.
Tables
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
recent_files
recent_files
Recently files (as displayed in Start Menu or File Explorer).
| Column | Type | Description |
|---|---|---|
| filename | text | The name of the file |
| mtime | bigint | Last modification time of the shortcut (usually corresponds to last opened time for the file) |
| path | text | The full path of the file |
| shortcut_path | text | Path to the shortcut where Windows stores the recent file data |
| type | text | Display type for the file |
| uid | bigint | The local user ID |
Example
SELECT recent_files.* FROM users CROSS JOIN recent_files USING (uid) WHERE mtime > unixepoch('now') - 3600Questions?
SOC2 Type 2
