Query: gmail_auto_forwarding_disabled

with all_users as (
  select primary_email as user_email from googledirectory_user
),
gmail_settings as (
  select 
    u.user_email,
    gs.auto_forwarding
  from all_users u
  left join googleworkspace_gmail_settings gs on gs.user_email = u.user_email
)
select
  user_email as resource,
  case
    when auto_forwarding ->> 'enabled' = 'false' or auto_forwarding ->> 'enabled' is null then 'ok'
    else 'alarm'
  end as status,
  case
    when auto_forwarding ->> 'enabled' = 'false' or auto_forwarding ->> 'enabled' is null then 'Auto-forwarding disabled for user: ' || user_email || '.'
    else 'Auto-forwarding enabled for user: ' || user_email || ' to: ' || coalesce(auto_forwarding ->> 'emailAddress', 'unknown address') || '.'
  end as reason
from
  gmail_settings;