preferences

OS X defaults and managed preferences.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: preferences

  • Mac OSX

Table schema

Name

Type

Description

domain

TEXT

Application ID usually in com.name.product format

key

TEXT

Preference top-level key

subkey

TEXT

Intemediate key path, includes lists/dicts

value

TEXT

String value of most CF types

forced

INTEGER

1 if the value is forced/managed, else 0

username

TEXT

(optional) read preferences for a specific user

host

TEXT

‘current’ or ‘any’ host, where ‘current’ takes precedence

Query examples

select * from preferences where domain = 'loginwindow'
select preferences.* from users join preferences using (username)