Hi everyone,
I was hoping that some of you would be able to give me some advice. I'm trying to figure out how many of my users have been active in the past three months.
I'm running Moodle 1.9. Any advice you could give me would be much appreciated.
If you have administration level access, go to the home page and click on users. Once in the user's view, click yje button to get to the advanced sorting tools. You want the Last login to be checked and set the "is after ..." set to a date three months ago. The system will not give you a numberical count, but by counting how many there are on one page you can multiply by the number of pages to get a pretty good estimate.
Ours had 30 per page and we had 38 full pages for a total of 1140 unique log ins since our school year began in the fall.
Another option you may enjoy is embedding a counter on to your home page. I like FlagCounter. It will post your unique visitors, page views, and also list all the flags from the countries that your students have logged in from. We have had ours on the site only one month but we have had the fun of seeing that 41 countries worth of flags are showing up. Another advantage is that you can compare the FlagCounter's page views to your log-ins that Moodle shows to get an idea of how many actual visitors, not just students, have hit your Moodle home page. Our counter shows about 4,000 total unique visits. That tels me that 4,000 minus our Moodle;s reported 1140 student log ins gives about 2800 hits that are not students. That would be the 'curious about your program', the web spiders, and the people just wanting to see what look your Moodle has to give them ideas about how they might design theirs. :0)
Hi Tammy,
Great idea. The only thing that's a little strange is that if I search by last access as opposed to last login, I get 3 times as many results over the same period of time.
Any idea what the difference between them might be?
"currentlogin" has the user's most recent login time; "lastlogin" has their second-most-recent login:
"lastaccess" contains the last time the user has been active within Moodle (has performed some action).
The "lastaccess" field of table "user_lastaccess", contains the last time the user has been active but BY COURSE (one record for each course the used has visited).
---
http://moodle.org/mod/forum/discuss.php?d=91184#p402855
Hi, just to add another possible solution... but in which you need access (e.g. via PHPMyAdmi) to your database:
1. Go to: http://www.epochconverter.com/
2. Enter the target date (current date minus three months) in the Mon/Day/Yr fields.
3. Click on the "Human date to Timestamp" button.
4. Copy the long number after the "Epoch timestamp" (e.g. 1323459499).
5. Adjust the following SQL command (check your table prefix and set the currentlogin value to the one previously copied):
SELECT COUNT(username) AS Users FROM mdl_user
WHERE currentlogin>='1323459499'
6. Run it.
You'll get the number of participants who have logged in the last three months, for example:
Users
11
That's fantastic. Exactly what I was looking for. I've had some difficulty learning the tables in my database. Can you recommend any sites that have good explanations of table structures for Moodle?
I'm glad it worked! About the Moodle DB:
That's what I'm looking for. Thanks!
Hi Guillermo Madero,
Thanks for this great idea. Its working. I am confused with current date minus three months what it mean? I want to fetch active users for August 2016 month only. What I should write here in timestemp.
Please guide. Thanks in advance.
Regards,
Nidhi