Are you looking for a way to find the users that have an unconfirmed email address? The Report Builder is what you are looking for! With this feature, you will be able to export a report of these users.
Just follow the steps below to create the report and then you will be able to find the users.
Go to the Reporting, under the Administration Panel, and then select Report Builder.
After selecting the Create New Report button you will be able to navigate to all the available predefined reports.
Find the Members Report into the group of Academy and click the continue button.
Add the Confirmed Emails field by choosing this from the list of the additional fields.
By adding this field you have the option to select the False value to depict the users who haven't confirmed their emails.
Save and Run the report and you will receive a list of the users who have unconfirmed emails!
The report will be saved under your Private Reports: