Which query to use to obtain info about which devices/ OS per user

We are trying to identify the OS and device model for our current Verivo Blackberry users. Let me know if this query provided below is accurate.

--User Info based on OS and device Model
select DeviceOSVersion
, DeviceModel
, FirstName
, LastName
from tmpcfg_User
where DeviceOSVersion is not null
order by DeviceOSVersion

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    John Lafauce

    Hi Lionel,

    That query should work fine on old and new databases. As a test, I executed that on a 7.2 DB, as well as a new 7.4.7 DB, and it worked well on both (please see image below).

    Thanks,

    John

     

    Device_OS_query.png

Please sign in to leave a comment.
Powered by Zendesk