Hi Chris

Thank you very much!


From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Chris 
Sent: Wednesday, April 19, 2017 1:32 PM
To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Renew Privilege

As far as I can tell, there's not a way to get that information from Evergreen 
reports.  You could do something like this to get a list of updated accounts 
from the previous day if you have direct access to the database server (which 
uses the auditor schema that tracks changes like that):

select u.id<http://u.id> as "User ID", aauh.expire_date as "Old Expire Date", 
u.expire_date as "New Expire Date" from auditor.actor_usr_history aauh join 
actor.usr u on (u.id<http://u.id> = aauh.id<http://aauh.id>) where 
date(aauh.audit_time) = date(now() - '1 day'::interval) and aauh.expire_date <> 
If you just want a count, just change the above to "select count(*) from...".
Hope that's helpful!

On Tue, Apr 18, 2017 at 1:27 PM, Carol Yarrison 
<cyarri...@biblio.org<mailto:cyarri...@biblio.org>> wrote:
I would also like this information.


On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis 
<eda...@albright.org<mailto:eda...@albright.org>> wrote:
Has anyone created a report counting how many users renewed their privilege in 
a time frame?
I was looking at the Action Trigger and User Activity Sources, but my 
investigating didn’t show any links to that information.


Elizabeth Davis
Head of Digital Services
Scranton Public Library
500 Vine Street
Scranton, PA 18509
570-348-3000 ext. 3050<tel:(570)%20348-3000>

“What in the world would we do without our libraries?”
― Katharine 

Carol Yarrison
Help Desk Coordinator/Trainer
Bibliomation, Inc
24 Wooster Ave
Waterbury, CT
203-577-4070 x112<tel:(203)%20577-4070>

Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147

Reply via email to