[Koha] How can i count the total catalog entry by user wise

Lennon Mazonde lmmazonde at gmail.com
Fri May 26 20:49:11 NZST 2017


Glad it worked. All credit to the authors of the reports. This 
particular was written by Nicole Engard.

Kind regards,

Lennon Mazonde

On 25/05/2017 18:43, Anastes Mp wrote:
> Lol...!
> Worked like a charm. Thanks for your support.
>
> On Thu, May 25, 2017 at 5:40 PM, Lennon Mazonde <lmmazonde at gmail.com 
> <mailto:lmmazonde at gmail.com>> wrote:
>
>     Hi Anastes,
>
>     You can  find SQL reports from the Koha SQL Reports wiki here
>     <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_items_added_by_cataloger_2>.
>     Go to More > Reports > Create from SQL. Give the report a name
>     that will help you remember what it's for (or just copy and paste
>     the details from the SQL Reports wiki).
>
>     Then copy and paste the following under the SQL tab.
>
>         SELECT concat(p.firstname, ' ', p.surname) AS staff,
>         concat(a.action, ' ', a.info <http://a.info>) AS action,
>         count(a.timestamp) AS count
>         FROM action_logs a
>         LEFT JOIN borrowers p ON (a.user=p.borrowernumber)
>         WHERE a.module='CATALOGUING' AND a.timestamp BETWEEN <<Between
>         (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
>               AND a.info <http://a.info> IN ('item','biblio')
>         GROUP BY p.borrowernumber, concat(a.action, ' ', a.info
>         <http://a.info>)
>
>     Save the report and run it. Oh, you need to turn the
>     CataloguingLog system preference on (More > Administration >
>     Global System Preferences > Logs > CataloguingLog.
>
>     Kind regards,
>
>     Lennon Mazonde
>
>     On 25/05/2017 13:48, Anastes Mp wrote:
>>     We've 4 staff in our library for catalog entry and each of them have koha
>>     librarian accounts. We would like analyze their work by counting the total
>>     number of books they entered.
>>     How can we count / generate report on the total number of books entered by
>>     a user?
>>
>
>
>
>
> -- 
>
> Regards
>
>
>   Anastes Mp
>
>
>       foranastes at gmail.com <mailto:foranastes at gmail.com>
>
>
>       +91-9744949078
>
> Facebook <http://www.facebook.com/toanasmp>Google 
> <https://google.com/+anastes>LinkedInTwitter



More information about the Koha mailing list