Query: List users that have NOT logged into the console in the past 90 days

Description

Determine the areas in which users have not been active for over 90 days, focusing on those with existing and active passwords. This is useful for identifying potentially dormant or unused accounts, helping to maintain security and efficiency within your system.

Query

Tables used in this query:

• alicloud_ram_credential_report

SQL