Highlighted
Absent Member.
Absent Member.
646 views

Problem querying list of users,devices,last connection time

Prior to our upgrade to Mobility version 1.2.5.4417 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 1.2.5.4417, 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.
Tom
Labels (1)
0 Likes
3 Replies
Highlighted
Absent Member.
Absent Member.

Re: Problem querying list of users,devices,last connection t

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 🙂
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Problem querying list of users,devices,last connection t

Thank you very much. Worked great!
0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: Problem querying list of users,devices,last connection t

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.
_____
Kevin Boyle - Knowledge Partner - Calgary, Alberta, Canada
Who are the Knowledge Partners?
If you appreciate my comments, please click the Like button.
If I have resolved your issue, please click the Accept as Solution button.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.