Report on Patron vs Entry Count in Koha

Error message

Deprecated function: Return type of DatabaseStatementBase::execute($args = [], $options = []) should either be compatible with PDOStatement::execute(?array $params = null): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2244 of /home/eduvai/public_html/includes/database/database.inc).
Deprecated function: Return type of DatabaseStatementEmpty::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
Deprecated function: Return type of DatabaseStatementEmpty::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
Deprecated function: Return type of DatabaseStatementEmpty::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
Deprecated function: Return type of DatabaseStatementEmpty::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).
Deprecated function: Return type of DatabaseStatementEmpty::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in require_once() (line 2346 of /home/eduvai/public_html/includes/database/database.inc).

admin's blog

This report will output the surname, firstname, cardnumber, record count and item count columns.

Uses: Count the koha data entry operators total statistics.

How to:

Login to koha staff interface
Go to reports
find create > from sql (see the picture no. 2)
Fill out the form using your own title

Run this report on koha:

SELECT borrowers.firstname, borrowers.surname, borrowers.cardnumber, COUNT(DISTINCT(biblio.biblionumber)) as 'Records', COUNT(DISTINCT(items.barcode)) as 'Items' FROM `action_logs` LEFT JOIN biblioitems on action_logs.object = biblioitems.biblionumber LEFT JOIN items on items.biblionumber = biblioitems.biblionumber LEFT JOIN biblio on biblio.biblionumber = items.biblionumber LEFT JOIN creator_batches on creator_batches.item_number = action_logs.object LEFT JOIN borrowers on borrowers.borrowernumber = action_logs.user LEFT JOIN biblioimages on biblioimages.biblionumber = action_logs.object WHERE action_logs.module = 'CATALOGUING' AND action_logs.action = 'ADD' AND info LIKE 'biblio%' GROUP BY borrowers.cardnumber