Query for log report

Query for log report

per Miki R -
Nombre de respostes: 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!

Mitjana de qualificacions: -
En resposta a Miki R

Re: Query for log report

per Przemek Kaszubski -
Imatge Particularly helpful Moodlers Imatge Testers
How about https://moodle.org/plugins/report_customsql ? Not sure it works with Postgresql , but do check it out.
En resposta a Przemek Kaszubski

Re: Query for log report

per Marcus Green -
Imatge Core developers Imatge Particularly helpful Moodlers Imatge Plugin developers Imatge 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.