Here's an example query: select rs.report, rs.folder, rr.create_time, rs.run_time, rs.complete_time, rs.email, aou.shortname, rr.owner, rr.name, rr.description, rr.template, rr.folder, rs.error_code, rs.error_text from reporter.schedule rs left join reporter.report rr on (rr.id = rs.report) left join actor.usr au on (au.id = rr.owner) left join actor.org_unit aou on (aou.id = au.home_ou) where run_time < now() order by run_time desc limit 500
essentially the email is in reporter.schedule Benjamin Murphy NC Cardinal Program Manager State Library of North Carolina [email protected] | https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal 109 East Jones Street | 4640 Mail Service Center Raleigh, North Carolina 27699-4600 The State Library is part of the NC Department of Natural & Cultural Resources. Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties. Please note new email address ________________________________ From: Evergreen-general <[email protected]> on behalf of JonGeorg SageLibrary via Evergreen-general <[email protected]> Sent: Thursday, October 10, 2024 6:09 PM To: Evergreen Discussion Group <[email protected]> Cc: JonGeorg SageLibrary <[email protected]> Subject: [External] [Evergreen-general] Report question CAUTION: External email. Do not click links or open attachments unless verified. Report suspicious emails with the Report Message button located on your Outlook menu bar on the Home tab. Is there a way to query the database to return what report by what user is using a particular email address for report completion notification? I have a situation where I'm getting bouncebacks for a particular email address. That address is no longer tied to any active user account. I'd previously found a few of the old automated reports generated by former staff where they'd used that email address on another staff account as notification when the automated report was done but it's still happening. -Jon ________________________________ Email correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official.
_______________________________________________ Evergreen-general mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
