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
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!
Any chance you'd be willing to share that view with me as well? mdorsey@spoletousa.org
Thanks!
Michael
On its way.