/build/static/layout/Breadcrumb_cap_w.png
10/16/2018 174 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

0
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