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

Description

Determine the areas in which users have an active console password but lack multi-factor authentication (MFA). This query is useful for identifying potential security risks within your Alicloud resource access management.

Query

Tables used in this query:

• alicloud_ram_credential_report

SQL