[OPEN-ILS-GENERAL] Renew Privilege

[Elizabeth Davis]

Hi Chris

Thank you very much!

Elizabeth

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Chris Sharp
Sent: Wednesday, April 19, 2017 1:32 PM
To: Evergreen Discussion Group <open-ils-general at 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 <> 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<mailto: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<mailto: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<tel:(570)%20348-3000>
edavis at albright.org<mailto: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<tel:(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/20170420/5d67f088/attachment-0001.html>