Query: iam_user_access_keys_and_password_at_setup

select
  user_arn as resource,
  case
    -- alarm when password is enabled and the key was created within 10 seconds of the user
    when password_enabled
    and (
      extract(
        epoch
        from
          (access_key_1_last_rotated - user_creation_time)
      ) < 10
    ) then 'alarm'
    else 'ok'
  end as status,
  case
    when not password_enabled then user_name || ' password login disabled.'
    when access_key_1_last_rotated is null then user_name || ' has no access keys.'
    when password_enabled
    and (
      extract(
        epoch
        from
          (access_key_1_last_rotated - user_creation_time)
      ) < 10
    ) then user_name || ' has access key created during user creation and password login enabled.'
    else user_name || ' has access key not created during user creation.'
  end as reason,
  account_id
from
  aws_iam_credential_report;