[Bug 38527] New: Add logging of reports (created, run, changed and deleted)
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 Bug ID: 38527 Summary: Add logging of reports (created, run, changed and deleted) Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: inkeri.hakulinen+bugz@helsinki.fi QA Contact: testopia@bugs.koha-community.org For GDPR reasons it would be good to have Koha to log the use of reports. I suggest that the log should include data about -who created which report and when and what the sql was -who run which report and when and what the sql was (the actual sql that was run, since sometimes you choose / fill in some parameters when you run the report) -who changed which report and when and how the sql was changed (before & after) -who deleted which report and when and what the sql was -probably also the updates to the report descriptions would be good to log? However, the results of the reports should not be saved into logs, of course. This addition would bring transparency about the use of the reports. That would be important for preventing misuse of customer data. Now Koha doesn't collect so detailed data, and it would be easy to collect customer data without a trace in the logs. This data would of course be helpful also in cases, when someone accidentally changes a report so that it doesn't work anymore. You could detect the old report from the logs. Also this would help solving crashes that happened due to running too heavy reports. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- hi Inkeri, the ReportsLog shoudl already cover these, did you test? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Bug 14024 and bug 27432 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 --- Comment #3 from Inkeri Hakulinen <inkeri.hakulinen+bugz@helsinki.fi> --- Ok, thanks. I hadn't found that option. Seems that there are two log viewers in Koha? One version accessed from the patron view doesn't even mention reports. Maybe this section is more for viewing the actions made to that borrower record. Then Through Tools -> Log viewer I can access a bit more detailed log viewer, that has also option "Reports" in it. However, it doesn't seem to show when reports are run. For me it shows "add", "delete" and "modify". But nothing that is "run". Might it be some setting in server that affects this? Should this log viewer also show running the reports? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Inkeri Hakulinen from comment #3)
Ok, thanks. I hadn't found that option.
Seems that there are two log viewers in Koha? One version accessed from the patron view doesn't even mention reports. Maybe this section is more for viewing the actions made to that borrower record. Then Through Tools -> Log viewer I can access a bit more detailed log viewer, that has also option "Reports" in it. However, it doesn't seem to show when reports are run. For me it shows "add", "delete" and "modify". But nothing that is "run". Might it be some setting in server that affects this? Should this log viewer also show running the reports?
Hi Inkeri, that's it exactly: when you access the logs from the patron record or an item record it's limited in the choices you can make to that user or bibliographic record. You are also right about "RUN", there are some patches that need more work on bug 27432. Maybe you can leave a comment there to get them moving again. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 Michelle Spinney <mspinney@clamsnet.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mspinney@clamsnet.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@openfifth.c | |o.uk Blocks| |22794 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22794 [Bug 22794] Improve and extend staff accessible logging in Koha -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38527 Angela Berrett <angela.berrett@familysearch.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |angela.berrett@familysearch | |.org --- Comment #5 from Angela Berrett <angela.berrett@familysearch.org> --- It looks like in the Action Logs we are still not logging when reports are run, or by whom. This would help us know when some reports can be deleted or when they should not be, especially if we can create queries about specific reports from the action logs. Can we revisit this development? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org