Moodle SQL for users who never have logged in
Simple query that works with postgres to find users who have not logged in.
select * from mdl_user where not exists (select * from mdl_user_lastaccess where mdl_user.id = mdl_user_lastaccess.id);
Simple query that works with postgres to find users who have not logged in.
select * from mdl_user where not exists (select * from mdl_user_lastaccess where mdl_user.id = mdl_user_lastaccess.id);
Comments
Comments powered by Disqus