What about running the following script against the Enterprise database on your Patient Portal Application Server? For our company I rule out the system records (donotreply and system); you may have to do the same. And by selecting that they have validated their email gives me the patients who have signed up for our portal. select kea..