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.
Solutions A small chevron
Device management

Device management

Remotely manage, and protect laptops and mobile devices.

Orchestration

Orchestration

Automate tasks across devices, from app installs to scripts.

Software management

Software management

Inventory, patch, and manage installed software.

GitOps

Fleet Gitops

See every change, undo any error, repeat every success.

Extend Fleet

Extend Fleet

Integrate your favorite tools with Fleet.

Customers Pricing
More A small chevron
Try it yourself Get a demo

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

password_policy

click to open the table of contents
macOS logo

password​_policy

OpenDirectory account policies for macOS including password content, authentication, and password change policies.

Column Type Description
policy_category text Policy category: passwordPolicyAuthentication, passwordPolicyPasswordChange, or passwordPolicyPasswordContent
policy_content text Policy content, such as policyAttributePassword matches '.{10,}'.
policy_description text Policy description, such as Contain at least 10 characters.
policy_identifier text Policy identifier, such as ProfilePayload:1d33ef8c-da1c-4534-8458-95a4d43d849e:minLength.
policy_parameters text Policy parameters serialized as JSON
uid bigint User ID for the policy. Returns -1 if the policy applies to all users.

Example

This policy query will return a 1 if the password policy requires passwords that are 10 characters or longer.

SELECT 1 FROM (SELECT cast(lengthtxt as integer(2)) minlength FROM (SELECT SUBSTRING(length, 1, 2) AS lengthtxt FROM (SELECT policy_description, policy_identifier, split(policy_content, '{', 1) AS length FROM password_policy WHERE policy_identifier LIKE '%minLength')) WHERE minlength >= 10);
Edit page

Questions?

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