<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
If you have SQL access to your database, we also use queries like this:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
select (EXTRACT(YEAR FROM aua.event_time) || '-' || LPAD(EXTRACT(MONTH FROM aua.event_time)::text,2,'0')) AS "Month", count(*) as CNT
<div class="ContentPasted0">from actor.usr_activity aua</div>
<div class="ContentPasted0">join actor.usr au on (au.id=aua.usr)</div>
<div class="ContentPasted0">where etype in(15) </div>
<div class="ContentPasted0">group by 1</div>
order by 1<br>
</div>
<div class="elementToProof">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
A few other criteria you can add to the WHERE statement:</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<span class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">-- if you want to limit by time period</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<span class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">and event_time between '2021-07-01'::date and '2022-06-30'::date</span>
<div class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">
<br>
</div>
<div class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">
<span style="display: inline !important; background-color: rgb(255, 255, 255);" class="ContentPasted2">-- if you want to limit by specific permission groups</span><br>
</div>
<div class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">
and au.profile = 86 </div>
<span class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<span class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<span class="ContentPasted0 ContentPasted1" style="margin: 0px; background-color: rgb(255, 255, 255);"><span style="display: inline !important; background-color: rgb(255, 255, 255);" class="ContentPasted3">-- if you want to limit by Org Unit System</span><br>
</span></div>
and au.home_ou in (select id from actor.org_unit_descendants(459)) </span><br class="Apple-interchange-newline ContentPasted1">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div class="WordSection1"></div>
<div class="WordSection1">
<p class="MsoNormal"><span style="color: black;"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">Benjamin Murphy<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">NC Cardinal Program Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">State Library of North Carolina<o:p></o:p></span></p>
<p class="MsoNormal"><u><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(5, 99, 193);"><a href="mailto:benjamin.murphy@ncdcr.gov" id="OWA7513a96e-521d-7d2c-e805-f70b0eaaba96" class="OWAAutoLink">benjamin.murphy@dcnr.nc.gov</a>
</span></u><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;"> |
<a href="https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal" id="OWA9385446b-ec24-369e-9d87-843a3c5935cb" class="OWAAutoLink">
https://statelibrary.ncdcr.gov/services-libraries/nc-cardinal</a></span><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">109 East Jones Street | 4640 Mail Service Center
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">Raleigh, North Carolina 27699-4600<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:6.0pt"><span style="font-size:10.0pt;
font-family:"Arial",sans-serif">The State Library is part of the NC Department of Natural & Cultural Resources.<o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black;">Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties.</span></i><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-ascii-font-family:
Calibri;mso-hansi-font-family:Calibri;mso-bidi-font-family:Calibri"><o:p><span style="background-color: rgb(255, 255, 0);">Please note new email address</span></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size: 11pt; color: rgb(0, 0, 0);"><b>From:</b> Evergreen-general <evergreen-general-bounces@list.evergreen-ils.org> on behalf of Susan Morrison via Evergreen-general <evergreen-general@list.evergreen-ils.org><br>
<b>Sent:</b> Thursday, August 31, 2023 12:26 PM<br>
<b>To:</b> Evergreen Discussion Group <evergreen-general@list.evergreen-ils.org><br>
<b>Cc:</b> Susan Morrison <smorrison@georgialibraries.org><br>
<b>Subject:</b> [External] Re: [Evergreen-general] counting OPAC logins</font>
<div> </div>
</div>
<div>
<div style="width: 100%; border-style: solid; border-color: rgb(156, 101, 0); border-width: 1pt; padding: 2pt; font-size: 10pt; line-height: 12pt; font-family: Calibri; text-align: left; color: black; background-color: rgb(255, 235, 156);">
<span style="font-weight: bold; color: rgb(255, 0, 0);">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">Hi Diane,<br>
<br>
There is a User Activity source in reports that can be used to show a count for User Activity Type "OPAC Login (tpac)."
<div><br>
</div>
<div>Here is a generalized/pared down example of one of the templates we've used:<br>
<div>
<div><br>
</div>
<div>-</div>
<div><b>Source: </b>User Activity. Nullability enabled.<br>
<br>
<b>Display Fields:</b><br>
User Activity -> (None nullable) User -> (None nullable) Home Library -> Short (Policy) Name as "Home Library"<br>
User Activity -> (None nullable) Activity Type -> Label as "Activity Type"<br>
User Activity -> ID (Count) as "Count"<br>
<br>
<b>Filters:</b></div>
<div>User Activity -> Event Time (Date) (Between)<br>
</div>
<div>-</div>
<div><br>
</div>
<div>Hope that helps!</div>
<div><br>
</div>
<div>Susan</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Thu, Aug 31, 2023 at 12:11 PM Diane Disbro via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org" id="OWA0c4840f5-3749-bc5a-ca17-e78c551b1b11" class="OWAAutoLink">evergreen-general@list.evergreen-ils.org</a>>
wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">Good morning -
<div><br>
</div>
<div>Does anyone use something other than Google Analytics to track OPAC logins?</div>
<div><br>
</div>
<div>Thanks.<br clear="all">
<div>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><font face="arial black, sans-serif">Diane Disbro</font></div>
<div dir="ltr">
<div>Pronouns: she/her</div>
<div>Circulation and Special Projects Coordinator</div>
<div>Scenic Regional Library</div>
<div>251 Union Plaza Drive</div>
<div>Union, MO 63084</div>
<div>(636) 583-0652 ext 110</div>
<div><span style="font-family:Raleway"><font style="color: rgb(0, 0, 0);"><a href="mailto:ddisbro@scenicregional.org" id="OWA8ac1542f-8f36-d220-7229-48f1e139033a" class="OWAAutoLink">ddisbro@scenicregional.org</a></font></span></div>
<div><span style="font-family:Raleway"><font style="color: rgb(0, 0, 0);"><br>
</font></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" id="OWA1ce8944f-b249-f0c7-2277-f56cb486f8ae" class="OWAAutoLink">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" data-auth="NotApplicable" id="OWAa0ac4a3c-56f9-3c87-53e0-16aa10a1819a" class="OWAAutoLink">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
<span class="x_gmail_signature_prefix">-- </span><br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<table style="border: none; border-collapse: collapse; color: rgb(34, 34, 34);">
<tbody>
<tr style="height:73.5pt">
<td colspan="2" style="vertical-align:top; overflow:hidden">
<p dir="ltr" style="line-height:1.2; text-align:right; margin-top:0pt; margin-bottom:0pt">
<span style="font-size: 11pt; font-family: Arial; vertical-align: baseline; white-space: pre-wrap; color: rgb(0, 0, 0); background-color: transparent;"><span style="border:none; display:inline-block; overflow:hidden; width:75px; height:75px"><img width="75" height="75" style="margin-left:0px; margin-top:0px" src="https://lh6.googleusercontent.com/lPbI_YgydcvRtZ9TiwKuc1KfifkdEMC3-KfRl4QTdqN-h28Z9PPyHJezIll2SZ58xvcMUDn6ucjj3UMF5z5PXUWXYwqkzKnaPC-Nn-BC7KEUI-ObVQoRjK-V5cHvzk7hJb4Gsz9n"></span></span></p>
</td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden">
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><span style="font-family: Verdana; font-weight: 700; vertical-align: baseline; white-space: pre-wrap; color: rgb(30, 67, 155);">Susan Morrison, PINES Operations Analyst</span></p>
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"></p>
<hr>
<p></p>
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><span style="font-size: 10pt; font-family: Verdana; font-weight: 700; vertical-align: baseline; white-space: pre-wrap; color: rgb(0, 0, 0); background-color: transparent;"></span><span style="font-size: 9pt; font-family: Verdana; font-weight: 700; vertical-align: baseline; white-space: pre-wrap; color: rgb(30, 67, 155); background-color: transparent;">Georgia
Public Library Service | University System of Georgia</span></p>
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><span style="font-size: 9pt; font-family: Verdana; vertical-align: baseline; white-space: pre-wrap; color: rgb(30, 67, 155); background-color: transparent;">2872 Woodcock Blvd, Suite 250
| Atlanta, GA 30341</span></p>
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><span style="font-size: 9pt; font-family: Verdana; vertical-align: baseline; white-space: pre-wrap; color: rgb(17, 85, 204);"><span style="font-family: Roboto, RobotoDraft, Helvetica, Arial, sans-serif; font-size: small; color: rgb(34, 34, 34);">(404)
235-7142 | </span><a href="mailto:smorrison@georgialibraries.org" style="color: rgb(17, 85, 204);" id="OWA219cdb2f-b5f2-062b-8b6b-6e15fce736aa" class="OWAAutoLink">smorrison@georgialibraries.org</a></span></p>
</td>
</tr>
<tr style="height:36pt">
<td colspan="2" style="vertical-align:top; overflow:hidden"><br>
</td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden">
<p dir="ltr" style="line-height:1.2; margin-top:0pt; margin-bottom:0pt"><a href="https://www.facebook.com/georgialibraries" data-auth="NotApplicable" style="color: rgb(17, 85, 204);" id="OWA6424c2b9-5d8c-bb3b-33a7-8c12e1704c6e" class="OWAAutoLink"><span style="font-size: 9pt; font-family: Verdana; vertical-align: baseline; white-space: pre-wrap; background-color: transparent;"><span style="border:none; display:inline-block; overflow:hidden; width:36px; height:36px"><img width="36" height="36" style="margin-left:0px; margin-top:0px" src="https://lh3.googleusercontent.com/l6IV_xNXIf2-f-NiUMiNpHTgeGTNM3K_Ff1h8g1LtzWypBjnioc4TjSEb7iNx1MMhT6yGrx3M9dHF3RGUXixqaoUAvcYGfFHtNx6Jdp7f-Z5dIrZTgDxkTYCBRFzBGtIpqBLEfBa"></span></span></a><a href="https://www.twitter.com/georgialibs" data-auth="NotApplicable" style="color: rgb(17, 85, 204);" id="OWA4f0d878a-7bf1-b42c-ac61-c2dc321e17f8" class="OWAAutoLink"><span style="font-size: 10pt; font-family: Verdana; vertical-align: baseline; white-space: pre-wrap; background-color: transparent;"><span style="border:none; display:inline-block; overflow:hidden; width:35px; height:35px"><img width="35" height="35" style="margin-left:0px; margin-top:0px" src="https://lh5.googleusercontent.com/mXs3mKgms5_2bKwJK2DCc0Uujst62CeFzq0CNM6zSaCV6s0poJ-aXnPN6o5s-NiId4uuD-48wZJIsEXVPF2mI10M83fGO-TpZ3lGL5hfNWFOQm6mE_AZSNHfFzOcfQAsmoXHUddy"></span></span></a><a href="https://www.instagram.com/georgialibraries/" data-auth="NotApplicable" style="color: rgb(17, 85, 204);" id="OWA64615bbb-5570-9c6d-b435-906c63e64fd2" class="OWAAutoLink"><span style="font-size: 11pt; font-family: Arial; vertical-align: baseline; white-space: pre-wrap; background-color: transparent;"><span style="border:none; display:inline-block; overflow:hidden; width:37px; height:37px"><img width="37" height="37" style="margin-left:0px; margin-top:0px" src="https://lh5.googleusercontent.com/1IT0gQU4FoKazU6kP8fw5PsE4y0xa7cbJw6M2EKJi_czDOILYvAotp-raDZyEXHFqOFQ6Y-W74qHjbDHQEuozu5_F8r08x9dlFpCgvlwDSu4gc3nRGqggMaTo9VjXyxMVe4o6DxM"></span></span></a></p>
</td>
</tr>
<tr style="height:36pt">
<td colspan="2" style="vertical-align:top; overflow:hidden"><br>
</td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden">
<p dir="ltr" style="line-height:1.2; margin-top:0pt; margin-bottom:0pt"><a href="http://georgialibraries.org/subscription" data-auth="NotApplicable" style="color: rgb(17, 85, 204);" id="OWAc6887ba6-67c4-4141-863c-023c07e9f53c" class="OWAAutoLink"><span style="font-size:10pt; font-family:Verdana; font-style:italic; vertical-align:baseline; white-space:pre-wrap">Join
our email list</span></a><span style="font-size: 10pt; font-family: Verdana; font-style: italic; vertical-align: baseline; white-space: pre-wrap; color: rgb(0, 0, 0);">
</span><span style="font-size: 10pt; font-family: Verdana; font-style: italic; vertical-align: baseline; white-space: pre-wrap; color: rgb(67, 67, 67);">for stories of Georgia libraries making an impact in our communities.</span></p>
</td>
</tr>
</tbody>
</table>
<span>
<div dir="ltr" align="left" style="margin-left:30.75pt">
<table style="border:none; border-collapse:collapse">
<colgroup><col width="76"><col width="7"><col width="64"><col width="437"></colgroup>
<tbody>
<tr style="height:73.5pt">
<td colspan="2" style="vertical-align:top; overflow:hidden"></td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden"></td>
</tr>
<tr style="height:36pt">
<td colspan="2" style="vertical-align:top; overflow:hidden"></td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden"></td>
</tr>
<tr style="height:0pt">
<td colspan="2" style="vertical-align:top; overflow:hidden"></td>
<td colspan="2" style="vertical-align:top; padding:5pt; overflow:hidden"></td>
</tr>
</tbody>
</table>
</div>
</span></div>
</div>
</div>
</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>