Query: drive_viewer_restrictions

select
  name as resource,
  case
    when copy_requires_writer_permission = true then 'ok'
    else 'alarm'
  end as status,
  case
    when copy_requires_writer_permission = true then 'Shared drive "' || name || '" restricts viewer download/print/copy capabilities.'
    else 'Shared drive "' || name || '" allows viewers to download/print/copy files.'
  end as reason
from
  googleworkspace_drive;