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
Stripe + Fleet
Stripe 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.
usb_devices
USB devices that are actively plugged into the host system.
Column | Type | Description |
---|---|---|
class | text | USB Device class |
model | text | USB Device model string |
model_id | text | Hex encoded USB Device model identifier |
protocol | text | USB Device protocol |
removable | integer | 1 If USB device is removable else 0 |
serial | text | USB Device serial connection |
subclass | text | USB Device subclass |
usb_address | integer | USB Device used address |
usb_port | integer | USB Device used port |
vendor | text | USB Device vendor string |
vendor_id | text | Hex encoded USB Device vendor identifier |
version | text | USB Device version number |
Identify Yubikeys currently connected. The model field contains information about what authentication protocols the keys are configured to support. This table can be used to track any type of USB device.
SELECT model, vendor, version FROM usb_devices WHERE vendor='Yubico';