Hi Chris Thank you very much!
Elizabeth From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Chris Sharp 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 <> 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 <cyarri...@biblio.org<mailto:cyarri...@biblio.org>> wrote: I would also like this information. Carol On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis <eda...@albright.org<mailto:eda...@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> eda...@albright.org<mailto:eda...@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