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?
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 ...Login frequency
This report is used to find the Technician and Requester Login frequency. SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP Address", ...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, ...Customized Login form
The following steps can performed to customise the default login page with a different image background. 1. Save a new page as Custom.HTML under [ManageEngine\ServiceDesk\Custom\Login]. This will return a totally blank login page with only the login ...Query to Pull out Login and LogOut History and to Find User Status
Purpose To generate the report which contains Login and LogOut History of the users and to find out the user status currently. Query 1 Below query provides the users login and logout history of the users. SELECT au.first_name as ...