Version : 11027

DB : PGSQL

OUTPUT :

Query :

SELECT AaaUser.FIRST_NAME "Technician",
       MAX(AaaLogin.NAME) "LoginName",
       MAX(AaaContactInfo.EMAILID) "Email",
       MAX(AaaAccSession.USER_HOST) "IP Address",
       longtodate(MAX(AaaAccSession.OPENTIME)) "Last Logged In Time" FROM AaaUser
INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID
LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID
INNER JOIN AaaAccount ON AaaAccount.login_id=AaaLogin.LOGIN_ID
INNER JOIN AaaAccSession ON AaaAccount.ACCOUNT_ID = AaaAccSession.ACCOUNT_ID
LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID
WHERE SDUser.STATUS = 'ACTIVE' and AaaAccSession.OPENTIME >= DATETOLONG('2023-01-01 00:00:00') and AaaAccSession.OPENTIME <= DATETOLONG('2023-01-31 23:59:59')
GROUP BY AaaUser.FIRST_NAME