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

Description

Determine the users who have console access but have never actually logged in. This can help identify unused accounts, enabling better management of user access and improving security by eliminating potential vulnerabilities.

Query

Tables used in this query:

• alicloud_ram_credential_report

SQL