Query: List users with console access that have never logged in to the console

Description

Discover the segments of users who have been granted console access but have never utilized it. This can be useful in identifying unnecessary access privileges and enhancing security measures.

Query

Tables used in this query:

• aws_iam_credential_report

SQL