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
python_packages
python_packages
Python packages installed in a system. NOTE: when querying on windows, even without a users cross join, all user installed python packages will be returned. This special behavior is to not break original functionality.
| Column | Type | Description |
|---|---|---|
| author | text | Optional package author |
| directory | text | Directory where Python modules are located |
| license | text | License under which package is launched |
| name | text | Package display name |
| path | text | Path at which this module resides |
| pid_with_namespace | integer | Pids that contain a namespace Only available on Linux |
| summary | text | Package-supplied summary |
| uid | bigint | The local user that owns the python package |
| version | text | Package-supplied version |
Example
List the versions of pip installed.
SELECT author, name, summary, version FROM python_packages WHERE name='pip';
Edit page
Ask us anything
Questions?
SOC2 Type 2
© 2025 Fleet Inc.
Privacy
