select os_version.version, case when from_base64(p2.value) like '%passwordLastSet%' or from_base64(p2.value) like '%PBKDF2%' then 1 else 0 end as password_set, case when p1.value = '*' then 0 else 1 end as root_enabled, u.shell, u.username as account_username from plist p1, plist p2, os_version, (select * from users where directory != '/var/empty') u where (p1.path = '/var/db/dslocal/nodes/Default/users/' || username || '.plist' and p1.key = 'passwd') and (p2.path = '/var/db/dslocal/nodes/Default/users/' || username || '.plist' and p2.key = 'accountPolicyData');