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

[Michael Hafen]

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> 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>
> 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> 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
>>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160721/f9b0233b/attachment.html>