Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

Apple

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
vscode_edition	text	VSCode or VSCode Insiders

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

Edit page

Ask us anything

Multi platform Device management Orchestration Software management Integrations Pricing

Documentation Support Docs API Release notes Get your license

Company About News Jobs Logos/artwork Why open source?

SOC2 Type 2

Tried Fleet yet?

Get started with Fleet