Query: ram_credential_entities_root_access_keys_table

select
  user_name as "User Name",
  'acs:ram::' || r.account_id || ':user/' || user_name as "User ARN",

  password_exist as "Password Enabled",
  mfa_active as "MFA Active",
  password_active as "Password Status",
  now()::date - password_last_changed::date as "Password Age in Days",
  password_last_changed as "Password Changed Timestamp",
  date_trunc('day',age(now(),user_last_logon))::text as "Password Last Used",
  user_last_logon as "Password Last Used Timestamp",
  date_trunc('day',age(now(),password_next_rotation))::text as "Next Password Rotation",
  password_next_rotation "Next Password Rotation Timestamp",

  access_key_1_active as "Access Key 1 Active",
  now()::date - access_key_1_last_rotated::date as "Key 1 Age in Days",
  access_key_1_last_rotated as "Key 1 Last Rotated",
  date_trunc('day',age(now(),access_key_1_last_used))::text as  "Key 1 Last Used",
  access_key_1_last_used as "Key 1 Last Used Timestamp",

  access_key_2_active as "Access Key 2 Active",
  now()::date - access_key_2_last_rotated::date as "Key 2 Age in Days",
  access_key_2_last_rotated as "Key 2 Last Rotated Timestamp",
  date_trunc('day',age(now(),access_key_2_last_used))::text as  "Key 2 Last Used",
  access_key_2_last_used as "Key 2 Last Used Timestamp",

  a.title as "Account",
  r.account_id as "Account ID"

from
  alicloud_ram_credential_report as r,
  alicloud_account as a
where
  a.account_id = r.account_id
order by
  user_name;