Re: [OPEN-ILS-GENERAL] Renew Privilege

[Elizabeth Davis]

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

Re: [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 
wrote:

> I would also like this information.
>
> Carol
>
> On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis 
> 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>
>>
>> eda...@albright.org
>>
>>
>>
>
>
>
> --
> “What in the world would we do without our libraries?”
> ― 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

Re: [OPEN-ILS-GENERAL] Renew Privilege

[Carol Yarrison]

I would also like this information.

Carol

On Tue, Apr 18, 2017 at 11:11 AM, Elizabeth Davis 
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>
>
> eda...@albright.org
>
>
>



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


Carol Yarrison
Help Desk Coordinator/Trainer
Bibliomation, Inc
24 Wooster Ave
Waterbury, CT
203-577-4070 x112

[OPEN-ILS-GENERAL] Renew Privilege

[Elizabeth Davis]

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
eda...@albright.org