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
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 ...Query to find the last logged time of a contact in the portal
select aas.session_id "SessionID", aal.name "User Name",aau.FIRST_NAME "Contact Name",org.NAME "Account Name", parentorg.NAME "Parent Account Name",suborg.name "Sub Account", aas.user_host "User Host", aas.application_host "Application Host", ...Query for Support Rep list in DB
Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...Excess license usage shown for support reps in SCP 8.1
1. Go to reports - > New query report, and execute the below query. select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...