Query: ram_user_unused_90

select
  'acs:ram::' || account_id || ':user/' || name as resource,
  case
    when last_login_date < current_date - interval '90 days' or last_login_date is null then 'alarm'
    else 'ok'
  end as status,
  case
    when last_login_date is null then name || ' never logged in.'
    else name || ' logged in '|| extract(day from current_date - last_login_date) || ' days ago.'
  end as reason
  , account_id as account_id
from
  alicloud_ram_user;