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 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)