Query: identity_auth_token_age_90

select
  user_id as resource,
  case
    when lifecycle_state = 'ACTIVE' and (date(current_timestamp) - date(time_created)) >= 90 then 'alarm'
    else 'ok'
  end as status,
  user_name || ' auth token created ' || to_char(time_created , 'DD-Mon-YYYY') ||
    ' (' || extract(day from current_timestamp - time_created) || ' days).'
  as reason
  , tenant_name as tenant
from
  oci_identity_auth_token;