Hello everyone,
I am trying to create a custom BigBlueButton log report with some extra fields. I have managed to create a similar log report of Big Blue Button. However, I am unable to get the "Meeting Left" data.
Can anyone please tell me how to get the required data?
Please find my query below and attached screenshots.
SELECT DISTINCT
FROM_UNIXTIME(bl.timecreated,'%d %b %Y, %H:%i') AS "Time",
CONCAT(u.firstname, ' ', u.lastname) AS "Student Name",
bn.name AS "Class Name",
c.fullname AS "Course name",
bl.log AS "Event",
g.name AS "Group Name"
FROM mdl_bigbluebuttonbn bn
JOIN mdl_bigbluebuttonbn_logs AS bl ON bn.id = bl.bigbluebuttonbnid
JOIN mdl_user AS u ON bl.userid = u.id
JOIN mdl_course AS c ON bl.courseid = c.id
JOIN mdl_groups AS g ON c.id = g.courseid
JOIN mdl_groups_members AS gm ON u.id = gm.userid AND g.id = gm.groupid
WHERE bn.name = "Online classroom 03.02.2021" AND c.id = 10
ORDER BY bl.timecreated DESC
Default BBB Log report:
Custom Log report
Moodle version: 3.7.5+
Thanks in Advance