Report of Last User on multiple device
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
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
