How to tell who is using the mobile application?

[yunis]

Hi there, first time here and with SNOW

we have a request to find out what users are using the mobile App vs. browser. Is this available? also would be nice to find out which devices.

thank you in advance

[Bharath40]

Hi,

You can check in transaction log , navigate to table syslog_transaction. Refer to this thread for more info How can you determine who is using the mobile interface?    

[jeroen9]

Hi Yunisbel,

You could look at the sys_mobile_devices table, which is the table that tracks mobile device identifiers (along with user and device meta data) needed for sending push notifications (APNs device tokens in Apple speak). As these identifiers are prone to change you need to keep in mind that there might be multiple entries with different identifiers for the same user/device combination. Additionally when an entry exists, it does not necessarily mean a device is still in active use as the app might be uninstalled or a newer entry might exist. Lastly, a record is only created if the user allows the app to receive push notifications (in the modal dialog on initial installation or through the App's settings menu); which means their might be some active users that do have a corresponding record in this table.

Taking these side notes into consideration, you should be able to determine with a relatively high certainty which unique users have been using the mobile Apps.

I hope this helps answering your question.

Cheers, Jeroen

[JC S_]

We can't seem to select sys_mobile_devices table when creating Reports.

[Michael160]

Have this same question.   Did you find out why you cannot report on this table?   sys_mobile_devices