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