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