• Replies 9 replies
  • Subscribers 337 subscribers
  • Views 131 views
  • Users 0 members are here
Related

Scheduled Reports received by Email address

Jess Levy
$organization

Hi

Is 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.

Thanks
Jess Levy
San Francisco Opera

Parents
  • $organization

     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%'-- recipients
    and cast(request_date_time AS date) = '2023-03-20'
    order by request_date_time desc

    Email :mdjaballah@philorch.org

Reply
  • $organization

     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%'-- recipients
    and cast(request_date_time AS date) = '2023-03-20'
    order by request_date_time desc

    Email :mdjaballah@philorch.org

Children