# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/aws/aws.iam_credential_report.dataset.md

---
title: IAM Credential Report
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > IAM Credential Report
---

# IAM Credential Report

This table represents the IAM Credential Report resource from Amazon Web Services.

```
aws.iam_credential_report
```

## Fields

| Title                          | ID   | Type       | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Description |
| ------------------------------ | ---- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------- |
| _key                           | core | string     |
| access_key_1_active            | core | bool       | When the user has an access key and the access key's status is Active, this value is TRUE. Otherwise it is FALSE.                                                                                                                                                                                                                                                                                                                                                        |
| access_key_1_last_rotated      | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's access key was created or last changed. If the user does not have an active access key, the value in this field is N/A (not applicable).                                                                                                                                                                                                                                                                |
| access_key_1_last_used_date    | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's access key was most recently used to sign an AWS API request. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                                                                                              |
| access_key_1_last_used_region  | core | string     | The <a href="https://docs.aws.amazon.com/general/latest/gr/rande.html">AWS Region</a> in which the access key was most recently used. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                                                                                       |
| access_key_1_last_used_service | core | string     | The AWS service that was most recently accessed with the access key. The value in this field uses the service's namespaceâfor example, s3 for Amazon S3 and ec2 for Amazon EC2. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                                             |
| access_key_2_active            | core | bool       | When the user has a second access key and the second key's status is Active, this value is TRUE. Otherwise it is FALSE.                                                                                                                                                                                                                                                                                                                                                  |
| access_key_2_last_rotated      | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's second access key was created or last changed. If the user does not have a second active access key, the value in this field is N/A (not applicable).                                                                                                                                                                                                                                                   |
| access_key_2_last_used_date    | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's second access key was most recently used to sign an AWS API request. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                                                                                       |
| access_key_2_last_used_region  | core | string     | The <a href="https://docs.aws.amazon.com/general/latest/gr/rande.html">AWS Region</a> in which the user's second access key was most recently used. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                                                                         |
| access_key_2_last_used_service | core | string     | The AWS service that was most recently accessed with the user's second access key. The value in this field uses the service's namespaceâfor example, s3 for Amazon S3 and ec2 for Amazon EC2. When an access key is used more than once in a 15-minute span, only the first use is recorded in this field.                                                                                                                                                               |
| account_id                     | core | string     |
| arn                            | core | string     | The Amazon Resource Name (ARN) of the user. For more information about ARNs, see <a href="https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html#identifiers-arns">IAM ARNs</a>.                                                                                                                                                                                                                                                                    |
| cert_1_active                  | core | bool       | When the user has an X.509 signing certificate and that certificate's status is Active, this value is TRUE. Otherwise it is FALSE.                                                                                                                                                                                                                                                                                                                                       |
| cert_1_last_rotated            | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's signing certificate was created or last changed. If the user does not have an active signing certificate, the value in this field is N/A (not applicable).                                                                                                                                                                                                                                              |
| cert_2_active                  | core | bool       | When the user has a second X.509 signing certificate and that certificate's status is Active, this value is TRUE. Otherwise it is FALSE.                                                                                                                                                                                                                                                                                                                                 |
| cert_2_last_rotated            | core | timestamp  | The date and time, in ISO 8601 date-time format, when the user's second signing certificate was created or last changed. If the user does not have a second active signing certificate, the value in this field is N/A (not applicable).                                                                                                                                                                                                                                 |
| mfa_active                     | core | bool       | When a <a href="https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_mfa.html">multi-factor authentication</a> (MFA) device has been enabled for the user, this value is TRUE. Otherwise it is FALSE.                                                                                                                                                                                                                                                         |
| password_enabled               | core | bool       | When the user has a password, this value is TRUE. Otherwise it is FALSE.The value for the AWS account root user is always not_supported.                                                                                                                                                                                                                                                                                                                                 |
| password_last_changed          | core | timestamp  | The date and time when the user's password was last set, in <a href="https://en.wikipedia.org/wiki/ISO_8601">ISO 8601 date-time format</a>. If the user does not have a password, the value in this field is N/A (not applicable). The value for the AWS account (root) is always not_supported.                                                                                                                                                                         |
| password_last_used             | core | timestamp  | The date and time when the AWS account root user or IAM user's password was last used to sign in to an AWS website, in <a href="https://www.iso.org/iso-8601-date-and-time-format.html">ISO 8601 date-time format</a>. AWS websites that capture a user's last sign-in time are the AWS Management Console, the AWS Discussion Forums, and the AWS Marketplace. When a password is used more than once in a 5-minute span, only the first use is recorded in this field. |
| password_next_rotation         | core | timestamp  | When the account has a <a href="https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_passwords_account-policy.html">password policy</a> that requires password rotation, this field contains the date and time, in <a href="https://en.wikipedia.org/wiki/ISO_8601">ISO 8601 date-time format</a>, when the user is required to set a new password. The value for the AWS account (root) is always not_supported.                                             |
| tags                           | core | hstore_csv |
| user                           | core | string     | The friendly name of the user.                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| user_creation_time             | core | timestamp  | The date and time when the user was created, in <a href="https://en.wikipedia.org/wiki/ISO_8601">ISO 8601 date-time format</a>.                                                                                                                                                                                                                                                                                                                                          |