[Evergreen-general] [External] Report question

[JonGeorg SageLibrary]

Thank you
-Jon

On Thu, Oct 10, 2024 at 5:00 PM Murphy, Benjamin via Evergreen-general <
evergreen-general at list.evergreen-ils.org> 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
>
> *benjamin.murphy at dncr.nc.gov <benjamin.murphy at dncr.nc.gov> * |
> 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 <
> evergreen-general-bounces at list.evergreen-ils.org> on behalf of JonGeorg
> SageLibrary via Evergreen-general <
> evergreen-general at list.evergreen-ils.org>
> *Sent:* Thursday, October 10, 2024 6:09 PM
> *To:* Evergreen Discussion Group <evergreen-general at list.evergreen-ils.org
> >
> *Cc:* JonGeorg SageLibrary <jongeorg.sagelibrary at gmail.com>
> *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
> Evergreen-general at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20241010/ad85633a/attachment.htm>