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';