SELECT AaaUser.FIRST_NAME "Technician",

MAX(AaaLogin.NAME) "LoginName",

MAX(AaaContactInfo.EMAILID) "Email",

MAX(AaaAccSession.USER_HOST) "IP Address",

longtodate(MAX(AaaAccSession.OPENTIME)) "Logged In Time" ,

longtodate(MAX(AaaAccSession.CLOSETIME)) "Logged Out Time"  FROM AaaUser 

INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID

INNER JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID

LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID 

LEFT JOIN AaaAccount ON AaaAccount.login_id=AaaLogin.LOGIN_ID

LEFT 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' GROUP BY AaaUser.FIRST_NAME

We are on version 11, build 11009

MSSQL database