Version : 11027

DB : Postgres

OUTPUT:

Select  au.FIRST_NAME  "Technicianname" ,
al.name "Login Name",
aci.emailid "EmailID",
SDUSER.STATUS "Status(Active/Inactive)",
longtodate(AaaAccSession.OPENTIME) "Logged In Date/Time",
AaaAccSession.user_host_name "Logged In From" from AaaUser au
left JOIN SDUser ON au.USER_ID=SDUser.USERID
INNER JOIN portaltechnicians ON SDUser.USERID=portaltechnicians.userid
left join aaausercontactinfo auci on auci.user_id = SDUser.userid
left join aaacontactinfo aci on aci.contactinfo_id = auci.contactinfo_id
left join AaaLogin al on au.USER_ID=al.USER_ID
left join AaaAccount aa on al.LOGIN_ID=aa.LOGIN_ID
LEFT JOIN AaaAccSession ON aa.ACCOUNT_ID = AaaAccSession.ACCOUNT_ID group by au.first_name,al.name,aci.emailid,sduser.status,aaaaccsession.opentime,aaaaccsession.user_host_name