https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42839 Anneli Österman <anneli.osterman@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |anneli.osterman@koha-suomi. | |fi --- Comment #1 from Anneli Österman <anneli.osterman@koha-suomi.fi> --- The SIP accounts are recorded in action_logs table and we have used this kind of report to check how many checkouts and returns have been down by certain SIP account: SELECT CONCAT(HOUR(timestamp), ':00-', HOUR(timestamp)+1, ':00') AS 'Hours', sum(IF(action = 'ISSUE', 1, 0)) AS 'Checkouts', sum(IF(action = 'RETURN', 1, 0)) AS 'Returns' FROM action_logs WHERE module = 'CIRCULATION' AND user = <<SIP account's borrowernumber>> AND timestamp BETWEEN <<Starting from|date>> AND <<Ending to|date>> AND action IN ('ISSUE','RETURN') GROUP BY HOUR(timestamp) Nevertheless, I'm all in for improvements. :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.