Product
User gets a failed job in the mail queue with the following error message:
A user is missing an email address in his/her Directory Entries.
select distinct p.person_codefrom persons pjoin mail_message_recipients mmr on mmr.object_type = 4 and mmr.object_id = p.person_idjoin queue_jobs qj on qj.job_id = mmr.message_id and qj.error_text like 'could not resolve%'