select * from ad_config;

select * from alf;

select * from alf_exceptions;

select * from alf_explicit_auths;

select * from alf_services;

select * from app_schemes;

select browser_plugins.* from users join browser_plugins using (uid);

select * from system_controls where subsystem = 'kern' and (name like '%boot%' or name like '%secure%' or name like '%single%');

select file.path, uid, gid, mode, 0 as atime, mtime, ctime, md5, sha1, sha256 from (select * from file where path like '/System/Library/CoreServices/%.efi' union select * from file where path like '/System/Library/LaunchDaemons/com.apple%efi%') file join hash using (path);

select * from fan_speed_sensors;