<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
Here's an example query:</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
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</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
from reporter.schedule rs</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
left join reporter.report rr on (rr.id = rs.report)</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
left join actor.usr au on (au.id = rr.owner)</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
left join actor.org_unit aou on (aou.id = au.home_ou)</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
where run_time < now()</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
order by run_time desc</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
limit 500</div>
<div id="Signature" class="elementToProof">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
essentially the email is in reporter.schedule</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<p><span style="color: black;"> </span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;"><b>Benjamin Murphy</b></span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;">NC Cardinal Program Manager</span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;">State Library of North Carolina</span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: rgb(5, 99, 193);"><u>benjamin.murphy@dncr.nc.gov
</u></span><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;"> |
<a href="https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal" style="margin-top: 0px; margin-bottom: 0px;">
https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal</a></span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;">109 East Jones Street | 4640 Mail Service Center </span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;">Raleigh, North Carolina 27699-4600</span></p>
<p style="margin-top: 6pt;"><span style="font-family: Arial, sans-serif; font-size: 10pt;">The State Library is part of the NC Department of Natural & Cultural Resources.</span></p>
<p><span style="font-family: Arial, sans-serif; font-size: 10pt; color: black;"><i>Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</i></span></p>
<p style="margin-bottom: 12pt;"><span style="background-color: rgb(255, 255, 0);">Please note new email address</span></p>
<p> </p>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Evergreen-general <evergreen-general-bounces@list.evergreen-ils.org> on behalf of JonGeorg SageLibrary via Evergreen-general <evergreen-general@list.evergreen-ils.org><br>
<b>Sent:</b> Thursday, October 10, 2024 6:09 PM<br>
<b>To:</b> Evergreen Discussion Group <evergreen-general@list.evergreen-ils.org><br>
<b>Cc:</b> JonGeorg SageLibrary <jongeorg.sagelibrary@gmail.com><br>
<b>Subject:</b> [External] [Evergreen-general] Report question</font>
<div> </div>
</div>
<div>
<div style="background-color:#FFEB9C; width:100%; border-style:solid; border-color:#9C6500; border-width:1pt; padding:2pt; font-size:10pt; line-height:12pt; font-family:'Calibri'; color:black; text-align:left">
<span style="color:#FF0000; font-weight:bold">CAUTION:</span> 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.</div>
<br>
<div>
<div dir="ltr">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?
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>-Jon</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
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.<br>
</font>
</body>
</html>