Query: drive_members_only_access

select
  name as resource,
  case
    when drive_members_only = true then 'ok'
    else 'alarm'
  end as status,
  case
    when drive_members_only = true then 'Shared drive "' || name || '" restricts access to members only.'
    else 'Shared drive "' || name || '" allows non-member access.'
  end as reason
from
  googleworkspace_drive;