Support rep last login time, start time, end time along with personal information
select aas.session_id "SessionID", aal.name "User Name",longtodate(aaauser.createdtime) as "User Created Time", aaacontactinfo.emailid "Email", aaacontactinfo.landline "Phone",aaacontactinfo.mobile "Mobile", aas.user_host "User Host", aas.application_host "Application Host",
longtodate(aas.opentime) "Login", longtodate(aas.closetime) "Logout",longtodate(aas.closetime) "Last Login", aas.status "Status" from AaaAccSession aas left join
aaalogin aal on aas.account_id=aal.login_id left join aaacontactinfo on aal.user_id=aaacontactinfo.contactinfo_id left join aaauser on aal.user_id=aaauser.user_id
longtodate(aas.opentime) "Login", longtodate(aas.closetime) "Logout",longtodate(aas.closetime) "Last Login", aas.status "Status" from AaaAccSession aas left join
aaalogin aal on aas.account_id=aal.login_id left join aaacontactinfo on aal.user_id=aaacontactinfo.contactinfo_id left join aaauser on aal.user_id=aaauser.user_id
New to ADSelfService Plus?
Related Articles
Query to take report of all techinician details with last login time (V10.6) (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) The query is compatiable with version 10.6 and above: Query: Select au.FIRST_NAME "Technicianname" , ar.NAME "Role",al.name "Login Name",aci.emailid "EmailID",SDUSER.STATUS ...Auto Populate Scheduled Start Time and End Time in Change Request
We can now auto-populate the Scheduled Start Time and End Time in a change request using FAFR. Under Admin>Change Template>Field and Form Rules, you can use the below scrips Scheduled Start Time var x=$CS.getValue("SCHEDULEDSTARTTIME"); if ( x === ...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 ...Query report to extract Active Technician Login and IP Address (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) Go to Reports- New Query Report and execute this query. select DISTINCT ac.ACCOUNT_ID as "Login Account ID", au.FIRST_NAME as "Technician Name ( First Name )", count(acs.SESSION_ID) as "Number of ...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", ...