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

Description

Identify users who may have abandoned their accounts or are no longer active by pinpointing those who haven't logged in for the past 90 days. This assists in maintaining secure and efficient user management by flagging potential inactive accounts for review or deletion.

Query

Tables used in this query:

• aws_iam_credential_report

SQL