How can i check users logged into controller

[raghu.vivek]

Hello , 

i wanted to know how many users out of the total numbers logged into app dynamics controller in last 10 days , is there a way to get list of users logged into app dynamics controller for a specific period of time

[Ravi.Biradar]

From the controller UI we don't have option to see who all logged in, but we can query the database to get the list of user logged in.

Please run below query to get the users list.

select from_unixtime(ts_ms/1000),account_name,user_name,action from controller_audit where action like '%login%' and user_name!='system';