[Koha-devel] log file of activities for admin of koha in the library

[rania azad mohammed]

Oh that's great, I will do the necessary modification then I will posted
back for the benifit of everyone, or you can added in the sql report
Will be back to you soon
Thanks again

On Thursday, 21 July 2016, Michael Hafen <michael.hafen at washk12.org> wrote:

> Ok, for the Guided Reports the SQL will be something like:
>
> SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action
> FROM action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber
> WHERE user <> 0 AND al.timestamp BETWEEN <<Between (yyyy-mmd-dd)|date>>
> AND <<And (yyyy-nn-dd)|date>> ORDER BY b.surname,b.firstname,al.timestamp
>
> You may want to adjust the order by with asc or desc qualifiers on the
> timestamp.
>
> But this only works for periods where you have the logging enabled, and
> only for those modules that are enabled.  For example I don't see
> circulation when I run that SQL because I don't have logging enabled for
> that module.
>
> On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed <
> rania.azad at auis.edu.krd
> <javascript:_e(%7B%7D,'cvml','rania.azad at auis.edu.krd');>> wrote:
>
>> Oh I see,
>> Can you help me on building the SQL query since I don't have a lot of
>> knowledge with SQL? simple report on librarian activities circulation,items
>> and cataloguing with date and time will be perfect
>>
>>
>>
>> On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen <michael.hafen at washk12.org
>> <javascript:_e(%7B%7D,'cvml','michael.hafen at washk12.org');>> wrote:
>>
>>> The action_logs table in the database could hold that information if you
>>> have turned on logging in the system preferences (
>>> http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs).
>>> There is a Log Viewer in Tools that may be useful for getting information
>>> from this table, or you can try building an SQL Report by hand.
>>>
>>> On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <
>>> rania.azad at auis.edu.krd
>>> <javascript:_e(%7B%7D,'cvml','rania.azad at auis.edu.krd');>> wrote:
>>>
>>>> Dear
>>>>
>>>> We are 3 admins in the library working on shifts in the library, each
>>>> of us log-in during her time. I want a report or log file to see all the
>>>> activities of each admin during a specific day. is there such report or
>>>> file? I tried to find it using the wiki but hopeless
>>>>
>>>> --
>>>>
>>>> *Regards,*
>>>>
>>>>
>>>> *Rania Azad |* Library Manager
>>>> Library Department
>>>> http://library.auis.edu.iq/
>>>> The American University of Iraq, Sulaimani
>>>> Office:
>>>> *B-G-32* Ext *1219*
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Koha-devel mailing list
>>>> Koha-devel at lists.koha-community.org
>>>> <javascript:_e(%7B%7D,'cvml','Koha-devel at lists.koha-community.org');>
>>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>>> website : http://www.koha-community.org/
>>>> git : http://git.koha-community.org/
>>>> bugs : http://bugs.koha-community.org/
>>>>
>>>
>>>
>>>
>>> --
>>> Michael Hafen
>>> Washington County School District Technology Department
>>> Systems Analyst
>>>
>>>
>>
>>
>> --
>>
>> *Regards,*
>>
>>
>> *Rania Azad |* Library Manager
>> Library Department
>> http://library.auis.edu.iq/
>> The American University of Iraq, Sulaimani
>> Office:
>> *B-G-32* Ext *1219*
>>
>>
>>
>
>
> --
> Michael Hafen
> Washington County School District Technology Department
> Systems Analyst
>
>

-- 

*Regards,*


*Rania Azad |* Library Manager
Library Department
http://library.auis.edu.iq/
The American University of Iraq, Sulaimani
Office:
*B-G-32* Ext *1219*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160721/3035f5f5/attachment-0001.html>