Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
vscode_extensions
Installed extensions for Visual Studio (VS) Code.
Column | Type | Description |
---|---|---|
installed_at | bigint | Installed Timestamp |
name | text | Extension Name |
path | text | Extension path |
prerelease | integer | Pre release version |
publisher | text | Publisher Name |
publisher_id | text | Publisher ID |
uid | bigint | The local user that owns the plugin |
uuid | text | Extension UUID |
version | text | Extension version |
SELECT * FROM users CROSS JOIN vscode_extensions USING (uid);
List the name, publisher, and version of the Visual Studio (VS) Code extensions installed on hosts.
SELECT extension.name, extension.publisher, extension.version FROM users JOIN vscode_extensions extension USING (uid);
Querying this table requires joining against the users
table. Learn more