HiIs there a way to see what scheduled reports are being sent to a specific email address? I am looking to put in place some clean up practices for when staff leave. Currently, I generally get a request from whoever is managing the old inbox to take them off the report distribution lists but it would be nice to be more proactive than that.
ThanksJess LevySan Francisco Opera
John, Could you kindly provide me with the SQL code you used to solve a similar problem? I have struggled with a similar issue for over a year and would greatly appreciate your assistance.To give you more context, I have been using a query to retrieve recent reports and search for specific emails within them to remove them.Thank you in advance for your help.
Best regards,Mohammed.
SQL
select * from gooesoft_request where 1=1 and email_recipients like '%mdjaba%'-- recipientsand cast(request_date_time AS date) = '2023-03-20'order by request_date_time desc
Email :mdjaballah@philorch.org
Mohammed Djaballah, not a problem, an e-mail should be making its way to you.
I got it, Thank you so much.
--Mohammed.