Thank you -Jon On Thu, Oct 10, 2024 at 5:00 PM Murphy, Benjamin via Evergreen-general < [email protected]> wrote:
> 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] <[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 >
_______________________________________________ Evergreen-general mailing list [email protected] http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
