Email notifications

Problem:
Need to find a way to send emails with all the hosts that are NOT running on puppet production branch

Expected outcome:
Receive an email with the lists of all hosts NOT running on puppet production branch

Foreman and Proxy versions:
1.20

Foreman and Proxy plugin versions:
1.20

Other relevant data:

I am trying to find a way of getting email from foreman on all the hosts that are not running on puppet production branch. I was able to set a custom BOOKMARK but i can’t find a way to make foreman send email with this information. Could you please help me to figure this out? I feel like this functionality has to be present in foreman. I was looking into default audit with custom queries but environment field doesn’t exist to pick. I looked into foreman-rake cronjobs but can’t find what i need. Thank you very much in advance.