Hi, hoping someone can shed some light on the mdl_user_devices table and what it's supposed to show you.
I'm pulling data into a PowerBI report and need to show (for example) how many users are completing courses on a mobile/tablet device and what device. I can see this table in the database logs this information but it looks to only register the device the first time you login with it. For example, I logged in to the app on my mobile and I can see the entry but it was in 2021. It hasn't picked up any subsequent logins on the device.
Is it actually possible to get the information I'm looking for? i.e. when a user completes a course, or logs in during a particular time period - are they on a mobile device?
Any help would be appreciated.