Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, software catalog Integrations
Docs Pricing
More
News Case studies Ask around Meetups Share your story
The handbook Get your license Schedule a demo
Try it yourself

Tables

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

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

windows_optional_features

click to open the table of contents
Windows logo

windows​_optional​_features

Lists names and installation states of windows features. Maps to Win32_OptionalFeature WMI class.

Column Type Description
caption text Caption of feature in settings UI
name text Name of the feature
state integer Installation state value. 1 == Enabled, 2 == Disabled, 3 == Absent
statename text Installation state name. 'Enabled','Disabled','Absent'

Example

SMBv1 is deprecated and has known, unpatched vulnerablities; it should be disabled whenever possible. This query lists enabled SMBv1 services (client and/or server).

SELECT name,caption,statename FROM windows_optional_features WHERE name LIKE 'SMB1Protocol%' AND state = 1;
Edit page

Questions?

Ask us anything
{{table.title}} evented table