Hello folks.
running redhat 6.8, mysql 5.7.31 , php 7.2.34.x and moodle 3.9.4+
we are cleaning up our external database enrolments and noticed this in our plugin setting
External database | 1133 / 7652 |
Our external db enrolment table is emptied out nightly and renamed as "manual" and that might have posed a problem in cleaning up?
What is the query to find the second one (7652 records)? I think I got the query for the first one but not the 2nd one.
I believe the first one is:
select count(courseid), enrol from mdl_enrol where enrol like '%atabas%' group by courseid, enrol desc;
just need the 2nd one so i can change them to manual LOL
trying to clean this up
thanks!