Moodle for mobile

Reporting on user usage of Moodle App to business

 
Picture of Sophie Hoskins
Reporting on user usage of Moodle App to business
 

Hi there,

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

 
Average of ratings: -
Picture of Marcus Green
Re: Reporting on user usage of Moodle App to business
Core developersParticularly helpful MoodlersPlugin developersTesters

What do you mean by usage/uptake?

 
Average of ratings: -
BHASVIC Downs and sea pattern orange
Re: Reporting on user usage of Moodle App to business
 

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.

Julia

VLE Coordinator at a sixth form college in the UK

 
Average of ratings: -
Picture of Ken Task
Re: Reporting on user usage of Moodle App to business
Particularly helpful Moodlers

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

 
Average of ratings: -
Picture of Sophie Hoskins
Re: Reporting on user usage of Moodle App to business
 

Thanks for sharing Ken! Appreciated smile!

 
Average of ratings: -
BHASVIC Downs and sea pattern orange
Re: Reporting on user usage of Moodle App to business
 

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?

Julia

 
Average of ratings: -
Picture of Ken Task
Re: Reporting on user usage of Moodle App to business
Particularly helpful Moodlers

Welcome. 

Now the question ... giving fish is not teaching how to fish.   I've 'given' you a fish.  Is this a 'teachable moment'? smile

Here's a 'how to fish'.

The columns in that table:

   Field name    Type    Allow nulls?    Key    Default value    Extras   
id bigint(10) No Primary NULL auto_increment
userid bigint(10) No Indexed 0
appid varchar(128) No None

name varchar(32) No None

model varchar(32) No None

platform varchar(32) No None

version varchar(32) No None

pushid varchar(255) No Indexed

uuid varchar(255) No Indexed

timecreated bigint(10) No None NULL
timemodified bigint(10) No None NULL

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.

Please see: https://www.google.com/search?q=mysql+sort+a+table

'spirit of sharing' ... and learning how to fish! smile

Ken



 
Average of ratings: -
Picture of Ken Task
Re: Reporting on user usage of Moodle App to business
Particularly helpful Moodlers
Follow up ... Google is your friend! smile

Date range ...

https://www.garron.me/en/bits/mysql-select-from-range-dates.html

'spirit of sharing' ... and learning how to fish! smile

Ken

 
Average of ratings: -
Picture of Marcus Green
Re: Reporting on user usage of Moodle App to business
Core developersParticularly helpful MoodlersPlugin developersTesters

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

https://moodle.org/plugins/report_customsql

 
Average of ratings: -