11th February 2020
Primary user on device
With this query you get a list of devices and topuser (primary user) on device
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT SMS_R_User.FullUserName, SMS_R_User.UniqueUserName, SMS_R_System.Name FROM SMS_R_System INNER JOIN SMS_G_System_SYSTEM_CONSOLE_USAGE ON SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceId = SMS_R_System.ResourceId INNER JOIN SMS_R_User ON SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser = SMS_R_User.UniqueUserName |