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
apt_sources
Current list of APT repositories or software channels.
| Column | Type | Description |
|---|---|---|
| architectures | text | Repository architectures |
| base_uri | text | Repository base URI |
| components | text | Repository components |
| maintainer | text | Repository maintainer |
| name | text | Repository name |
| pid_with_namespace | integer | Pids that contain a namespace Only available on Linux |
| release | text | Release name |
| source | text | Source file |
| version | text | Repository source version |
On Ubuntu or other Debian based systems, identify APT repositories that are not maintained by Ubuntu.
SELECT * FROM apt_sources WHERE maintainer!='Ubuntu';