select root_enabled, password_set, shell, os_version.version, 'root' as user_account from os_version, (select case when from_base64(value) like '%passwordLastSet%' then 1 else 0 end as password_set from plist where path = '/var/db/dslocal/nodes/Default/users/root.plist' and key = 'accountPolicyData') policy, (select case when value = '*' then 0 else 1 end as root_enabled from plist where path = '/var/db/dslocal/nodes/Default/users/root.plist' and key ='passwd') enabled, users where policy.password_set = 0 and users.uid = 0 ;