/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


Report of Last User on multiple device

10/16/2018 620 views
Is there a way to run a report to see who is using more than once device? For example I search for jsmith in search field and it shows Last User jsmith logged into 3 devices. 
0 Comments   [ + ] Show comments

Comments


All Answers

1
That should be easy enough to create using the reporting wizard, but here's a query you can use:
SELECT LAST_USER, COUNT(ID), GROUP_CONCAT(NAME) FROM ORG1.MACHINE 
GROUP BY LAST_USER
ORDER BY LAST_USER

Answered 10/17/2018 by: chucksteel
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ