Query: elastic_beanstalk_environment_managed_updates_enabled

with beanstalk_environment_logs_enabled as (
  select
    distinct e.arn
  from
    aws_elastic_beanstalk_environment as e,
    jsonb_array_elements(e.configuration_settings) as c,
    jsonb_array_elements(c -> 'OptionSettings') as s
  where
    s ->> 'OptionName' = 'ManagedActionsEnabled'
    and s ->> 'Value' = 'true'
  group by
    arn
)
select
  e.arn as resource,
  case
    when l.arn is not null then 'ok'
    else 'alarm'
  end as status,
  case
    when l.arn is not null then title || ' managed actions Enabled.'
    else title || ' managed actions disabled.'
  end as reason
  
, region, account_id
from
  aws_elastic_beanstalk_environment as e
  left join beanstalk_environment_logs_enabled as l on e.arn = l.arn;