How can we get Moodle students registration data?

How can we get Moodle students registration data?

by Arpita Chopra -
Number of replies: 2

Hello Everyone,


I am a Masters by Research student from Malaysia. I want to know that is there any way to get the registered student data from Moodle for my project, How can I get the data?

Average of ratings: -
In reply to Arpita Chopra

Re: How can we get Moodle students registration data?

by Tom Smith -
Do you have access to the server? If yes, you can connect to the SQL database directly and query the mdl_user (from memory) table. You would need to be able to login on the command line and then login to the (probably MySQL) server from the command line. If you don't know what that means or how to do it, then probably you need to be liaising with whomever are the sys admins.
In reply to Arpita Chopra

Re: How can we get Moodle students registration data?

by Prince Namdev -
You can install a plugin called configurable reports in Moodle. Here is the link => https://moodle.org/plugins/block_configurable_reports.

Then you can write a query to get the registered user data.

Select * from mdl_user; // To get all users

Select * from mdl_user where auth = email; // To get all users who have registered themselves and not created by your lms admin.