Using moodle 3.9.4 on rhel 6.8 and php 7.3 and mysql 5.7
I noticed in the participant pages of course, the students don't have any roles attached to them.
Does anyone have a query for me to test and run against our courses? I know they have a search filter that does the same but I want to find out which tables and joins are needed to find out where and why they don't have any roles.
Then i can write a script to perhaps update those to all students.