Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
python_packages
Python packages installed in a system.
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 |
version | text | Package-supplied version |
List the versions of pip installed.
SELECT author, name, summary, version FROM python_packages WHERE name='pip';