Is there a report tool/log for Moodle 2.4 which admin can use to see what the students are messaging to each other to combat bullying.
Hi Nadine,
I think you could get that info from the database itself, via phpMyAdmin, for example, or with the Custom SQL queries report.
I've been wondering this myself. So I tried the Custom SQL queries report plugin Guillermo suggested (it's listed as 'Ad-hoc database queries' in the plugins directory here: https://moodle.org/plugins/view.php?plugin=report_customsql). Thanks for the tip, Guillermo.
Some MySQL queries I tried:
1) ALL unread messages
SELECT FROM_UNIXTIME (timecreated,"%Y-%m-%d"), useridfrom, useridto, subject, smallmessage FROM `{message}` ORDER BY FROM_UNIXTIME (timecreated,"%Y-%m-%d")
2) Recent READ messages (within the last week)
SELECT FROM_UNIXTIME (timecreated,"%Y-%m-%d"), useridfrom, useridto, subject, smallmessage FROM `{message_read}` WHERE FROM_UNIXTIME (timecreated,"%Y-%m-%d") > DATE_SUB(CURDATE(), INTERVAL 1 WEEK) ORDER BY FROM_UNIXTIME (timecreated,"%Y-%m-%d")
Boris.
Excellent!