To find the details about number of users logged in to the application and other related informations

To find the details about number of users logged in to the application and other related informations

In order to find the details about the list of users logging time to host, their logout time and current status of their connections. Please use the below query,


select aas.session_id "SessionID", aal.name "User Name", aas.user_host "User Host", aas.application_host "Application Host", 

longtodate(aas.opentime) "Start Time", longtodate(aas.closetime) "End Time", aas.status "Status" from AaaAccSession aas left join 

aaalogin aal on aas.account_id=aal.login_id