Query: List members that failed email verification

Description

Uncover the details of members who have not successfully completed the email verification process. This is particularly useful for identifying potential security issues and ensuring all users have been properly validated.

Query

Tables used in this query:

• aws_guardduty_member

SQL