Tested in 14620

SELECT aaauser.FIRST_NAME AS "Name", aal.NAME AS "Login", aaacontact.EMAILID AS "E-Mail", deptTable.DEPTNAME AS "Department", sduser.JOBTITLE AS "Job title", STRING_AGG (arole.name, ',') "Assigned Role", (SELECT STRING_AGG (adef.org_name, ',') FROM TechnicianAccountMapping tam INNER JOIN AccountDefinition adef ON adef.org_id = tam.accountid WHERE tam.TECHNICIANID =poTech.USERID ) AS "Associated Accounts", (SELECT STRING_AGG (sdo.name, ',') FROM UserSiteMapping usm  INNER JOIN SDOrganization sdo ON sdo.ORG_ID = usm.SITEID  WHERE usm.USERID = poTech.USERID ) AS "Associated Sites", (SELECT STRING_AGG (qdef.queuename, ',') FROM Queue_Technician qt INNER JOIN QueueDefinition qdef ON qt.QUEUEID = qdef.QUEUEID  WHERE qt.TECHNICIANID = poTech.USERID) AS "Associated Groups", domaininfo.DOMAINNAME AS "Domain" FROM AaaUser aaauser LEFT JOIN SDUser sduser ON aaauser.USER_ID = sduser.USERID INNER JOIN PortalTechnicians poTech ON sduser.USERID = poTech.USERID LEFT JOIN Aaalogin aal ON poTech.USERID = aal.USER_ID LEFT JOIN AaaAccount acc ON aal.login_id = acc.login_id LEFT JOIN SDAuthorizedRole auth ON acc.account_id = auth.account_id LEFT JOIN AaaRole arole ON auth.role_id = arole.role_id LEFT JOIN AaaUserContactInfo aaausercontact ON aaauser.USER_ID = aaausercontact.USER_ID LEFT JOIN AaaContactInfo aaacontact ON aaausercontact.CONTACTINFO_ID = aaacontact.CONTACTINFO_ID LEFT JOIN UserDepartment userDept ON poTech.USERID = userDept.USERID LEFT JOIN DepartmentDefinition deptTable ON userDept.DEPTID = deptTable.DEPTID LEFT JOIN DomainInfo domaininfo ON sduser.DOMAIN_ID = domaininfo.DOMAINID GROUP BY aaauser.FIRST_NAME, poTech.USERID, aal.NAME, aaacontact.EMAILID, deptTable.DEPTNAME, sduser.JOBTITLE, domaininfo.DOMAINNAME