If you have SQL access to your database, we also use queries like this: select (EXTRACT(YEAR FROM aua.event_time) || '-' || LPAD(EXTRACT(MONTH FROM aua.event_time)::text,2,'0')) AS "Month", count(*) as CNT from actor.usr_activity aua join actor.usr au on (au.id=aua.usr) where etype in(15) group by 1 order by 1
A few other criteria you can add to the WHERE statement: -- if you want to limit by time period and event_time between '2021-07-01'::date and '2022-06-30'::date -- if you want to limit by specific permission groups and au.profile = 86 -- if you want to limit by Org Unit System and au.home_ou in (select id from actor.org_unit_descendants(459)) Benjamin Murphy NC Cardinal Program Manager State Library of North Carolina benjamin.mur...@dcnr.nc.gov<mailto:benjamin.mur...@ncdcr.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-boun...@list.evergreen-ils.org> on behalf of Susan Morrison via Evergreen-general <evergreen-general@list.evergreen-ils.org> Sent: Thursday, August 31, 2023 12:26 PM To: Evergreen Discussion Group <evergreen-general@list.evergreen-ils.org> Cc: Susan Morrison <smorri...@georgialibraries.org> Subject: [External] Re: [Evergreen-general] counting OPAC logins 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. Hi Diane, There is a User Activity source in reports that can be used to show a count for User Activity Type "OPAC Login (tpac)." Here is a generalized/pared down example of one of the templates we've used: - Source: User Activity. Nullability enabled. Display Fields: User Activity -> (None nullable) User -> (None nullable) Home Library -> Short (Policy) Name as "Home Library" User Activity -> (None nullable) Activity Type -> Label as "Activity Type" User Activity -> ID (Count) as "Count" Filters: User Activity -> Event Time (Date) (Between) - Hope that helps! Susan On Thu, Aug 31, 2023 at 12:11 PM Diane Disbro via Evergreen-general <evergreen-general@list.evergreen-ils.org<mailto:evergreen-general@list.evergreen-ils.org>> wrote: Good morning - Does anyone use something other than Google Analytics to track OPAC logins? Thanks. Diane Disbro Pronouns: she/her Circulation and Special Projects Coordinator Scenic Regional Library 251 Union Plaza Drive Union, MO 63084 (636) 583-0652 ext 110 ddis...@scenicregional.org<mailto:ddis...@scenicregional.org> _______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org<mailto:Evergreen-general@list.evergreen-ils.org> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general -- [https://lh6.googleusercontent.com/lPbI_YgydcvRtZ9TiwKuc1KfifkdEMC3-KfRl4QTdqN-h28Z9PPyHJezIll2SZ58xvcMUDn6ucjj3UMF5z5PXUWXYwqkzKnaPC-Nn-BC7KEUI-ObVQoRjK-V5cHvzk7hJb4Gsz9n] Susan Morrison, PINES Operations Analyst ________________________________ Georgia Public Library Service | University System of Georgia 2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341 (404) 235-7142 | smorri...@georgialibraries.org<mailto:smorri...@georgialibraries.org> [https://lh3.googleusercontent.com/l6IV_xNXIf2-f-NiUMiNpHTgeGTNM3K_Ff1h8g1LtzWypBjnioc4TjSEb7iNx1MMhT6yGrx3M9dHF3RGUXixqaoUAvcYGfFHtNx6Jdp7f-Z5dIrZTgDxkTYCBRFzBGtIpqBLEfBa]<https://www.facebook.com/georgialibraries>[https://lh5.googleusercontent.com/mXs3mKgms5_2bKwJK2DCc0Uujst62CeFzq0CNM6zSaCV6s0poJ-aXnPN6o5s-NiId4uuD-48wZJIsEXVPF2mI10M83fGO-TpZ3lGL5hfNWFOQm6mE_AZSNHfFzOcfQAsmoXHUddy]<https://www.twitter.com/georgialibs>[https://lh5.googleusercontent.com/1IT0gQU4FoKazU6kP8fw5PsE4y0xa7cbJw6M2EKJi_czDOILYvAotp-raDZyEXHFqOFQ6Y-W74qHjbDHQEuozu5_F8r08x9dlFpCgvlwDSu4gc3nRGqggMaTo9VjXyxMVe4o6DxM]<https://www.instagram.com/georgialibraries/> Join our email list<http://georgialibraries.org/subscription> for stories of Georgia libraries making an impact in our communities. ________________________________ 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@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
