Table: aws_iam_credential_reports
This table shows data for IAM Credential Reports.
The composite primary key for this table is (arn, user_creation_time).
Columns
| Name | Type |
|---|---|
| _cq_source_name | utf8 |
| _cq_sync_time | timestamp[us, tz=UTC] |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| arn (PK) | utf8 |
| user_creation_time (PK) | timestamp[us, tz=UTC] |
| password_last_changed | timestamp[us, tz=UTC] |
| password_next_rotation | timestamp[us, tz=UTC] |
| access_key_1_last_rotated | timestamp[us, tz=UTC] |
| access_key_2_last_rotated | timestamp[us, tz=UTC] |
| cert_1_last_rotated | timestamp[us, tz=UTC] |
| cert_2_last_rotated | timestamp[us, tz=UTC] |
| access_key_1_last_used_date | timestamp[us, tz=UTC] |
| access_key_2_last_used_date | timestamp[us, tz=UTC] |
| password_last_used | timestamp[us, tz=UTC] |
| password_enabled | utf8 |
| user | utf8 |
| password_status | utf8 |
| mfa_active | bool |
| access_key1_active | bool |
| access_key2_active | bool |
| cert1_active | bool |
| cert2_active | bool |
| access_key1_last_used_region | utf8 |
| access_key1_last_used_service | utf8 |
| access_key2_last_used_region | utf8 |
| access_key2_last_used_service | utf8 |
