Symptoms
We need to create a report about customers that have already confirmed the email. How can we do that?
Resolution
The only way to find list if confirmed/not-confirmed emails is in database:
pba=> select "UsersID","Email" from "EmailConfirmationStatus" ;
And then you can get ID of the account:
pba=> select "AccountID" from "Users" WHERE "UsersID"=[user_id_from_previous_select];
Feature request #PBA-52323 to implement such functionality in PBA-E CP.