Query for log report

Query for log report

by Miki R -
Number of replies: 2

Hello everyone! I need help.

I have Moodle 3.6 based on Postgresql and I would like make a select query on the database in order to have the log report present in Site Administration-> Report-> Log.

Is it possible to recover this data by making a select query on the database?

Thank you!

Average of ratings: -
In reply to Miki R

Re: Query for log report

by Przemek Kaszubski -
Picture of Particularly helpful Moodlers Picture of Testers
How about https://moodle.org/plugins/report_customsql ? Not sure it works with Postgresql , but do check it out.
In reply to Przemek Kaszubski

Re: Query for log report

by Marcus Green -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
I can confirm it works with Postgresql. The UK Open University use/maintain it and they are big into PG. And it would probably do what the questioner is asking.