Support rep last login time, start time, end time along with personal information

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

      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 ...
            • 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 ...