I need to run a report on Moodle App usage/uptake in our organisation.
I haven't be able to locate a system report (via site admin) that will help me report on these statistics. Can someone help me please?!!
Best regards, Sophie
I also would like to know how many of my users are logging in to our Moodle site using the Mobile app. How do I find this out please? Where is this information stored?
Any hints gratefully received.
VLE Coordinator at a sixth form college in the UK
Does your DB have a mdl_user_devices table?
If so, one could query that table:
select userid,model,platform,version from `mdl_user_devices`
User devices with link to user info and device link ... query should be on one line. Line breaks ... break the query.
select concat('<a target="_new" href="https://yoursite/user/profile.php?id=',userid,'">',userid,'</a>'),
concat('<a target="_new" href="https://www.google.com/search?q=',model,'">',model,'</a>'),
platform,version from `mdl_user_devices
'spirit of sharing', Ken
Thanks for sharing Ken! Appreciated !
This is great, Ken. Thank you. It worked (of course)!
Do you know how I would add a date range to the query, if such a thing is possible?
Now the question ... giving fish is not teaching how to fish. I've 'given' you a fish. Is this a 'teachable moment'?
Here's a 'how to fish'.
The columns in that table:
The last two columns probably contain what you seek. Hint those are epoch time stamps ... numbers ... that when viewed with modification will show date/time and with a change to the query one could sort on either.
'spirit of sharing' ... and learning how to fish!
Sophie, this is the sort of query that would be suitable for running with the ad-hoc query plugin so you could get it directly from within Moodle rather than firing up a separate program. Substitute the mdl prefix according to instructions. You can see the plugin her