select ac.ACCOUNT_ID as "Account Id", au.FIRST_NAME as "User Name", LONGTODATE(acs.OPENTIME) as "Login Time", LONGTODATE(acs.OPENTIME) as "Login Time",  LONGTODATE(acs.CLOSETIME) as "Logout Time", acs.USER_HOST as "IP Address", al.NAME as "Login Name", al.DOMAINNAME as "Domain Name", aci.EMAILID as "Email address", LONGTODATE(au.CREATEDTIME) as "Account Created Time", repuser.FIRST_NAME as "Reporting To", sd.ISVIPUSER as "IsVipUser" from aaauser au left join AaaUserContactInfo auci on au.USER_ID=auci.USER_ID left join AaaContactInfo aci on auci.CONTACTINFO_ID = aci.CONTACTINFO_ID inner join sduser sd on au.USER_ID=sd.USERID left join UserDepartment ud on sd.USERID = ud.USERID left join DepartmentDefinition dd on ud.DEPTID=dd.DEPTID inner join aaalogin al on au.USER_ID = al.USER_ID inner join aaaaccount ac on al.LOGIN_ID = ac.LOGIN_ID left join aaaaccsession acs on ac.ACCOUNT_ID = acs.ACCOUNT_ID left join aaauser repuser on repuser.USER_ID = sd.REPORTINGTO where acs.CLOSETIME > 0 and acs.OPENTIME between <from_lastweek> and <to_lastweek> order by acs.OPENTIME;