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
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 ->
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
What I have done is when replacing a damaged book with a new copy, instead
of deleting, I just use "replace barcode" to make evergreen think the new
time is the old item with a new barcode. Then I update any information that
needs changed like price if we paid a different amount for the
