Query: List users that have a console password but do not have MFA enabled

Description

Explore which users have an active console password but lack multi-factor authentication. This is useful for identifying potential security vulnerabilities within your AWS IAM user base.

Query

Tables used in this query:

• aws_iam_credential_report

SQL