Tables

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

Apple

Linux

Windows

ChromeOS

password_policy

Password Policies for macOS.

Column	Type	Description
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`.
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