Query: iam_credential_entities_root_access_keys_table

select
  user_name as "User Name",
  user_arn as "User ARN",

  password_enabled as "Password Enabled",
  mfa_active as "MFA Active",
  password_status 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(),password_last_used))::text as "Password Last Used",
  password_last_used 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_date))::text as  "Key 1 Last Used",
  access_key_1_last_used_date as "Key 1 Last Used Timestamp",
  access_key_1_last_used_region as "Key 1 Last Used Region",
  access_key_1_last_used_service as "Key 1 Last Used Service",

  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_date))::text as  "Key 2 Last Used",
  access_key_2_last_used_date as "Key 2 Last Used Timestamp",
  access_key_2_last_used_region as "Key 2 Last Used Region",
  access_key_2_last_used_service as "Key 2 Last Used Service",

  cert_1_active as "Cert 1 Active",
  now()::date - cert_1_last_rotated::date as "Cert 1 Age in Days",
  cert_1_last_rotated "Cert 1 Last Rotated",

  cert_2_active as "Cert 2 Active",
  now()::date - cert_2_last_rotated::date as "Cert 2 Age in Days",
  cert_2_last_rotated as "Cert 2 Last Rotated",

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

from
  aws_iam_credential_report as r,
  aws_account as a
where
  a.account_id = r.account_id
order by
  user_name;