OS X defaults and managed preferences.
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
|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|
select * from preferences where domain = 'loginwindow'
select preferences.* from users join preferences using (username)