Problem querying list of users,devices,last connection time

Prior to our upgrade to Mobility version we followed this TID: Support | How to get a list of users, devices and the last connection time for the devices in order to find out which users were added to Mobility, but had not connected a device in 30 days. This command (psql -U datasync_user mobility -c "select userid,deviceid,identifierstring,tstamp from devices" -H > /tmp/output.html) used to generate a list with the users ldap user id before we upgraded. Since, we now receive a numeric/has user identifier instead of the ldap user id.

Does anyone know if the field containing that information has changed and we need to reference a different field in the database?

Thank you for any help you can provide.
  • SELECT * FROM users INNER JOIN devices ON (users.guid = devices.userid) ORDER by tstamp DESC

    That will give you a bit more info then you might be looking for but it will have the requested data :)
  • TSchmauch;2280860 wrote:
    Thank you very much. Worked great!

    Feedback is important (both negative and positive) and always appreciated. In the past we have we have not actively solicited feedback from the Community and left it up to individual Members to provide feedback (as you did in your post) when they saw fit... but this is changing.

    When you, or anyone for that matter, see a post you find particularly helpful you can show your appreciation by clicking on the star below the post. You can optionally leave a brief comment which is always appreciated but it is not necessary.

    Clicking on the star assigns reputation points to the poster but more importantly it identifies those posts you find most helpful and notifies both the poster and website administrators. Our goal is to improve the way we support the Community by providing the type of information you find most useful. For that to happen, Members' feedback is essential!

    Thank you.