Query: ram_password_policy_expire_365_or_greater

select
  'acs:ram::' || a.account_id as resource,
  case
    when max_password_age is null then 'alarm'
    when max_password_age >= 365 then 'ok'
    else 'alarm'
  end as status,
  case
    when max_password_age is null then 'Password expiration not set.'
    else 'Password expiration set to ' || max_password_age || ' days.'
  end as reason
  , a.account_id as account_id
from
  alicloud_account as a
  left join alicloud_ram_password_policy as pol on a.account_id = pol.account_id;