Messages: Is there a tool to Monitor student messages?

Messages: Is there a tool to Monitor student messages?

nadine neita -
回帖数：3

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.

平均分： -
回复nadine neita

Re: Messages: Is there a tool to Monitor student messages?

G. M. -

Hi Nadine,

I think you could get that info from the database itself, via phpMyAdmin, for example, or with the Custom SQL queries report.

平均分：Useful (1)
回复G. M.

Re: Messages: Is there a tool to Monitor student messages?

Boris Puhanic -

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.

平均分： -