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

      New to ADSelfService Plus?

        Resources

            • Related Articles

            • Login Frequency Query Report

              The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician",        MAX(AaaLogin.NAME) "LoginName",        MAX(AaaContactInfo.EMAILID) "Email",        MAX(AaaAccSession.USER_HOST) "IP ...
            • Last logged in time of SupportReps

              select max(au.first_name)'Technician',al.name"Login Name", longtodate(max(acs.opentime))"Last Logged in Time" from aaaaccsession acs left join aaaaccount act on act.account_id=acs.account_id left join aaalogin al on al.login_id=act.login_id left join ...
            • Duplicate users while importing from AD

              Use the below queries; To find the number of duplicate users:  SELECT objectguid, COUNT(*) TotalCount FROM aduser GROUP BY objectguid HAVING COUNT(*) > 1; SELECT userid, samaccname, objectguid, COUNT(*) TotalCount FROM aduser GROUP BY userid, ...
            • How to change login page image/logo in SCP 8.1

              1. Go to Admin - > Global settings - > Application settings - > Settings. 2. Under Logo settings, you can import a custom image with the specified size, and you can use the image to be shown on the login page.
            • List of contacts logged into the system

              Mysql select aas.session_id "SessionID", aal.name "User Name",aau.FIRST_NAME "Contact Name",org.NAME "Account Name", aas.user_host "User Host", aas.application_host "Application Host", longtodate(aas.opentime) "Start Time", longtodate(aas.closetime) ...