Version : 10.6

DB : MSSQL

OUTPUT :

select qd.QUEUEID,
qd.QUEUEDESCRIPTION,
qd.QUEUENAME "Support group",
ownedby.FIRST_NAME AS "Owned By",
au.FIRST_NAME "Technician",
qe.email "Group EMAIL" from QueueDefinition qd
left join Queue_Technician qt on qd.QUEUEID=qt.QUEUEID
left join sitedefinition sdf on qd.QUEUEID=sdf.siteid
left join SDOrganization sdorg on sdf.siteid=sdorg.org_id
left join accountdefinition ad on sdorg.org_id=ad.org_id
left join SdUser sd on qt.TECHNICIANID=sd.USERID
left join AaaUser au on sd.USERID=au.USER_ID
left join queue_email qe on qd.QUEUEID = qe.QUEUEID
LEFT join supportgroup supg on qd.ciid = supg.ciid
LEFT JOIN AaaUser ownedby ON supg.OWNEDBY=ownedby.USER_ID