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
Drill into every scheduled report, or use SQL. If you have SQL access, let me know, and I'll share some code.
Jess,
Requires SQL, but I have a local VIEW that I have moved into System Tables via a customization by Katie Lachance-Duffy that shows the next scheduled instance of every scheduled report and the relevant details about it, including the e-mail addresses to which it is being sent. Then, using the standard functionality of System Tables, I can simply search for the e-mail address I need. I use it often to find all reports being sent to a current staff member and/or make sure we are not scheduling 15 runnings of the same exact report at 7:02 AM every day since that often creates issues. And because it is a VIEW rather than a defined table, it always just finds the next scheduled instance of the report rather than having to be searched.
I am happy to send over my view if that would help. Certainly easy to reference from inside SQL as well. jmoskal@thecenterpresents.org
John A. Moskal II
That would be great! Thank you!
That's a great idea, John A. Moskal II!
We query the report queue from the backend after staff leave their organization in our Consortium to handle this type of thing.
Recently, though, we realized that we can't query Analytics in the same way, nor can Sys Admin level users see all Analytics dashboards, so we don't currently have a way of removing departed staff members from those scheduled reports. We'll most likely put an Idea to solve for that on the Ideas board at some point soon!
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.
Any chance you'd be willing to share that view with me as well? mdorsey@spoletousa.org
Thanks!
Michael
On its way.