[OPEN-ILS-GENERAL] Renew Privilege

[Chris Sharp]

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 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 = aauh.id) where date(aauh.audit_time) = date(now() -
'1 day'::interval) and aauh.expire_date <> u.expire_date;

If you just want a count, just change the above to "select count(*)
from...".

Hope that's helpful!

Chris



On Tue, Apr 18, 2017 at 1:27 PM, Carol Yarrison <cyarrison at biblio.org>
wrote:

> I would also like this information.
>
> Carol
>
> On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis <edavis at albright.org>
> wrote:
>
>> Hello
>>
>> 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.
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Elizabeth Davis
>>
>> Head of Digital Services
>>
>> Scranton Public Library
>>
>> 500 Vine Street
>>
>> Scranton, PA 18509
>>
>> 570-348-3000 ext. 3050 <(570)%20348-3000>
>>
>> edavis at albright.org
>>
>>
>>
>
>
>
> --
> “What in the world would we do without our libraries?”
> ― Katharine Hepburn
> <http://www.goodreads.com/author/show/84099.Katharine_Hepburn>
>
> Carol Yarrison
> Help Desk Coordinator/Trainer
> Bibliomation, Inc
> 24 Wooster Ave
> Waterbury, CT
> 203-577-4070 x112 <(203)%20577-4070>
>



-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170419/679b13c4/attachment.html>