[Evergreen-general] [External] Report question

[Murphy, Benjamin]

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  | 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20241010/61d50be9/attachment-0001.htm>