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