Copy-pasting from an email exchange regarding the addition of device information to files downloaded ad-hoc report on Moodle:
the device used by the user whether tablets supplied by us or smartphones
This information is not directly captured in the logs, so we cannot put this directly in the files downloaded per user report.
But we do have the
prefix_user_devices table,
which
logs which mobile device a user has logged in from, including the
time-stamp of when they first logged in from that device.
So, we could write a separate queries for things like:
1. How many users are using the tablets provided by us
2. How many users are using mobile phones or other tablets
3. Which devices a particular user has used, including the time periods
and so on.
Also, we must note:
This
table would not have entries if the user has logged in using a web
browser - even if it was a tablet or mobile. Only those devices which
use the Moodle app or our mobile app would be logged in this table.